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

From Kolus Maximiliano
Subject Re: SETOF (was: Function example returning more then 1
Date
Msg-id A56C8EE648A74A4F9653B071E9F71420BC5181@bcrweb.bcr.com.ar
Whole thread Raw
Responses Re: SETOF (was: Function example returning more then 1  (Antti Haapala <antti.haapala@iki.fi>)
Re: SETOF (was: Function example returning more then 1  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: SETOF (was: Function example returning more then 1  (Darko Prenosil <darko.prenosil@finteh.hr>)
List pgsql-general

>       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))"?

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: PGSQL function question
Next
From: Peter Eisentraut
Date:
Subject: Re: XML in PostgreSQL