[GENERAL] FUNCTION DEFINITION

Hi, If I have created a plpgsql function, is there a way I can look again at the create statement of that function. I need to know what exactly is there in the function. Thanks Abhang ---(end of broadcast)--- TIP 3: Have you checked our extensi

[GENERAL] gist index on cube column

Hi, I had some doubts about the gist index on cube column. So if I have a column of type cube and create a gist index on it, would the index be on individual elements in the cube or the cube as a whole. I mean will a gist index on cube column improve the performance of earthdistance function o

[GENERAL] cube problem

Hi, I have a table with one column as real[]. Now if I want to make cubes out of each of these arrays, is there a way in postgre I can do it. I guess cube operator is not defined for real[] but can I create cubes if the column was integer[]. If yes please may I know how. Actually I would pass

[GENERAL] cube for real[]

Hi, I have a table with one column as real[]. Now if I want to make cubes out of each of these arrays, is there a way in postgre I can do it. I guess cube operator is not defined for real[] but can I create cubes if the column was integer[]. If yes please may I know how. Thanks Abhang -

[GENERAL] cube for real[]

Hi, I have a table with one column as real[]. Now if I want to make cubes out of each of these arrays, is there a way in postgre I can do it. I guess cube operator is not defined for real[] but can I create cubes if the column was integer[]. If yes please may I know how. Thanks Abhang -

[GENERAL] function problem

Hi, I have written a function called similarity in postgresql which accepts real[] as argument. I then call it by saying select * from similarity('{1.232,5., 5.100, 1}'); I get this error. Could not choose a best candidate function. You may need to add explicit type casts. Is it th

[GENERAL] COPY error

Hi, Im trying to load data from a file using copy command. At the end of the data, I have appended copy statement as copy tablename(col1, col2) from stdin with delimiter as '\t'; .\ But I get following error. ERROR: syntax error at or near "2713" LINE 1: 2713 {3.70952,1.45728,0.134339,3.99197

[GENERAL] REMOTE CONNECTION

Hi, I have installed postgre 8.2.4. I tried to modify the pg_hba.conf and .conf file for allowing remote connection but it did not work. The server is a linux machine. I am trying to connect with my laptop by ssh client. Please may I know what other parameters need to be tweaked. I get an erro

[GENERAL] opclass for real[]

Hi, I have a column real[] in my table. I need to create a gist index on it. But the error is obvious as follows. ERROR: data type real[] has no default operator class for access method "gist" HINT: You must specify an operator class for the index or define a default operator class for the

[GENERAL] cube

Hi, Can you please let me know if anyone has used cube.c file in postgresql. I have installed the contrib modules required, but I just need to know how to implement cube operator on a table. Thanks Abhang ---(end of broadcast)--- TIP 9: In vers

[GENERAL] CUBE SYNTAX

Hi, I need to use the cube operator in postgresql 8.2. Whats the syntax for the cube or a link to the documentation which clearly explains how to use cube operator syntactically. Thanks Abhang ---(end of broadcast)--- TIP 6: explain analyze is

[GENERAL] contirb install

Hi, I have redhat enterprpise release 4. I need to use the cube operator. Please can you let me know to install the necessary contrib modules. I tried to make in the directory of the contrib but it says Makefile:23: ../../src/Makefile.global: No such file or directory Makefile:24: /contrib/con

[GENERAL] contrib

Hi, I have installed postgresql 8.2 on redhat enterprise release WS 4. I need to use the cube operator which I guess resides in the contrib modules. Please may I know the link to install the appropricate contrib module for my linux machine. Thanks Abhang ---(end of b

Re: [GENERAL] cube operations

Hi, But now having 12 columns and multicolumn index, wont this slow down the search process. I mean in general retrieving 12 columns using a multicolumn index is slower or faster compared to an index on a 12 size array? Thanks Abhang Quoting "John D. Burger" <[EMAIL PROTECTE

[GENERAL] cube operations

Hi, I have a array column which has 12 real values in it. Basically these values represent co-ordinates in 12 dimensions for a substance. My main need is to find substances similar to a particular compound. Now I can do by calculating differences with each array in the whole table. But the tab