Re: SETOF (was: Function example returning more then 1

From: Kolus Maximiliano <Kolus(dot)maximiliano(at)bcr(dot)com(dot)ar>
To: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>, pgsql-general(at)postgresql(dot)org
Subject: Re: SETOF (was: Function example returning more then 1
Date: 2003-02-27 13:56:54
Message-ID: A56C8EE648A74A4F9653B071E9F71420BC5181@bcrweb.bcr.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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))"?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Nuzum 2003-02-27 13:58:14 selective copy
Previous Message Peter Eisentraut 2003-02-27 13:49:57 Re: XML in PostgreSQL