From: jack <datactrl@tpg.com.au>
To: pgsql-sql@postgresql.org
Subject: Re: pl/pgsql how to return multiple values from a function
Date: Sun, 9 Mar 2003 15:42:18 +1000
Message-ID: <002101c2e5fe$a76a2340$1400a8c0@jac> (raw)
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,
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: datactrl@tpg.com.au
Subject: Re: pl/pgsql how to return multiple values from a function
In-Reply-To: <002101c2e5fe$a76a2340$1400a8c0@jac>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox