I found following notes on news list with Google. And I have a try but it
still doesn't work. The problem is pl/pgsql complains that function of col1
is not found. My postgres is v7.3.2. Please help. Thank you in advance.
Jack
------
Sure you can, I wouldn't nessessarily recommend it. rec_tmp must be a
table somewhere so it can be a 'type', you get the values from the record
by using syntaxt like SELECT col1(teste_tmp(1)), col2(teste_tmp(1)),
col3(teste_tmp(1));
You could also return a CURSOR but I've never tried that (I access
PostgreSQL from perl's DBI which doesn't support a cursor return type).
Joshua b. Jore ; http://www.greentechnologist.org ; 10012 11010 11022
10202 1012 2122 11020 10202 10202 11002 1020 1012 11102 11102 11102 1201
11001 11002 10211 11020 10202 10202 11002 11021 1201 11010 11020 10211
On Tue, 28 May 2002, Vilson farias wrote:
> Greetings,
>
> I would like to know if it's possible to return a record from a pl-pgsql
> function.
>
> The procedure I did is bellow and of course doesn't work. Is there some
> possibility or work-around?
>
> CREATE FUNCTION teste_tmp(INT4)
> RETURNS RECORD AS '
> DECLARE
> rec_tmp record;
> BEGIN
> SELECT
> INTO rec_tmp
> 1 as col1, ''teste'' as col2, now() as col3 ;
>
> RETURN rec_tmp;
> END;
> '
> LANGUAGE 'plpgsql';
>
> Best regards,
>