From: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Returning types - PL-PgSql functions |
Date: | 2002-05-28 20:15:58 |
Message-ID: | 003b01c20684$7bc011f0$98a0a8c0@dgtac |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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,
----------------------------------------------------------------------------
----
José Vilson de Mello de Farias
Software Engineer
Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson(dot)farias(at)digitro(dot)com(dot)br
Tel.: +55 48 281 7158
ICQ 11866179
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua b. Jore | 2002-05-28 20:39:00 | Re: Returning types - PL-PgSql functions |
Previous Message | Chris Humphries | 2002-05-28 18:05:25 | [chumphries@devis.com: Re: triggers cant see functions] |