Returning types - PL-PgSql functions

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

Responses

Browse pgsql-general by date

  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]