Hi,
> Nope, see my reply from yesterday around 20:23
> You can return a table instead, with the count added as an
> extra column.
I did see your solution, but note that it does not return a tuple
consisting of an integer and a setof (as I wanted), but instead
returns a setof of a tuple.
I still haven't found a solution to the original problem. The
best I can do so far is to create a function that returns a tuple
consisting of an int and the first row of table results (see below).
Any more thoughts?
Best regards,
Jon
create table users
(
uid int4 not null,
name text not null,
age int4 not null,
primary key (uid)
);
create type page_t AS
(
total int4,
users users
);
create function get_page ()
returns page_t
language plpgsql as
$$
declare
_total int4;
_users users;
_page page_t;
begin
select count (*) from users into _total;
select * from users limit 10 into _users;
_page := row (_total, _users);
return _page;
end
$$;