Re: SETOF (was: Function example returning more then 1 - Mailing list pgsql-general

On Thursday 27 February 2003 13:56, Kolus Maximiliano wrote:
> >     You can't return more than one return value from function, but that
> > value can be of composite type.For example :"setof text" or "setof
> > record" are such types.
>
>     Can you use functions returning "setof"s as if they were "normal"
> selects?.
>
>     I saw that setof takes a type or table as an argument. What if what
> i want to return is not in a table schema, can i do something like "setof
> (blah inet, blah2 varchar(256))"?


SETOF RECORD as shown at :
    http://developer.postgresql.org/docs/postgres/sql-select.html

or custom declared composite type:
    http://developer.postgresql.org/docs/postgres/sql-createtype.html