Re: composite types - Mailing list pgsql-general

Ivan Sergio Borgonovo wrote:

> I've found this
> http://archives.postgresql.org/pgsql-general/2001-03/msg01459.php
> but I'd like to avoid to declare a table just for a temp.
>
> pseudocode follow
>
> declare struct pippo(
>     integer a;
>     varchar(8) b;
> )
>
> create or replace function functiontest( ) returns pippo
> as '
> declare
>     integer tempa;
>     varchar(8) tempb;
>

I think you might want to look at SRFs (Set Returning Functions).  Here
are a couple of links:

http://techdocs.postgresql.org/guides/SetReturningFunctions
http://www.varlena.com/varlena/GeneralBits/26.html