[GENERAL] How to fetch the RefCursor in via ODBC??

; COMMIT; However, when I try to call this function via ODBC ( namely in the Borland DBExplorer ). It got none information for me! I am wondoring is ODBC supporting RefCursor, since the FAQ of GBorg said the ODBC only support simple data type. Therefore, does

[GENERAL] test

test ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Which schema I am woking on??

ot exist Firstly, is there anyway to find out which Schema I am working on, so I could query the pg_tables with a specified schemaname?? I have tried to select current_schema. However, it always return "public" to me. Second, I am wondering how could I drop the automically crea

[GENERAL] function with multi-values

ssible to make it to return something like - petersusanjohn I have to use this result to print in quick report. THANK YOU VERY MUCH Harry Yau ---(end of broadcast)--- TIP 2: you can get off all lists at once with th

[GENERAL] Re: Re: function with multi-values

>On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote: >> Dear: >> I wanna create a function that return a multiple rows in to a single >> >> row. >> example: >> CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM >> TEST

[GENERAL] function return multiple value

ssible to make it to return something like - petersusanjohn I have to use this result to print in quick report. THANK YOU VERY MUCH Harry Yau ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster