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