2011/1/14 Jon Smark <jon.smark@xxxxxxxxx>: > Hi, > > This thread has veered off-topic, but my original problem still remains. > Basically, I want to declare a function that returns a tuple consisting > of an integer and a set of table rows. ÂSomething like the following: > > CREATE FUNCTION foobar () RETURNS (int4, SETOF users) > you have to use a array CREATE FUNCTION foo(... OUT total int, OUT _users users[]) there are no other way Regards Pavel Stehule > Now, if I understand correctly, the only way to have a function return > a tuple is to create a named record and have the function return that > record: > > CREATE TYPE page_t AS > Â( > Âtotal Âint4 > Âusers ÂSETOF users > Â) > > Which is of course not grammatical. ÂSo, how does one solve this problem > in PL/pgSQL? > > Thanks in advance! > Jon > > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
