On Mon, Jun 18, 2012 at 4:30 AM, utsav <utsav.ps...@tcs.com> wrote: > Thanks for reply but you have used SQL as a language . > > Please give me Plpgsql example because i am facing problem in plpgsql only
create function f(foo out foo, bar out bar) returns setof record as $$ begin return query select (v, v::text)::foo, (v, v::text)::bar from generate_series(1,3) v; end $$ language plpgsql; -- or -- create or replace function f(foo out foo, bar out bar) returns setof record as $$ begin f.foo = (1,'a')::foo; f.bar = (2,'b')::bar; return next; end $$ language plpgsql; (in older versions of postgres you might have to be a little more careful about names of input and output arguments). merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
