[SQL] How can I read display message from a C function

Hi All:     I would like to put some message in my C function ( myTestFunction). Currently, I want to see time for each function call inside myTestFunction. The output to the screen commands are in myTestFunction. myTestFunction is called from postgresql. How can I see the messages? Thanks

Re: [SQL] Update question

PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gábriel Ákos Sent: Tuesday, March 28, 2006 12:34 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Update question Markus Schaber wrote: > Hi, Fay, > > Fay Du wrote: >> Table cost >> >> Id edge_idcost >&

[SQL] Update question

Hi all:   I have a table like this:   Table cost Id  edge_id    cost 1   30 101.4 2   30  null 3   40  500.2 4   40   null 5    45  300.7 6    45   null   I want to set cost value with same edge_id by same

[SQL] pgsql2shp - Could not create dbf file

Hi everyone: I got an error when I use pgsal2shp. My server is Linux The command I used is: pgsql2shp -f newroads gisdb testarea Where, newroads is my out put file name, gisdb is database name, and testarea is table name. After hit enter button, I got the mess

[SQL] How can I selet rows which have 2 columns values cross equal?

Hi All: I have a table like this: Table test Id | a | b -++--- 1| 100| 101 2| 101| 100 3| 100| 3 4| 20 | 30 5| 11 | 13 6| 3 | 33 7| 30 | 20 I want to get row 1, 2,4 and 7 selected. Because their values of a and b are cross equal. i.e., for each pair of r