On Wed, Jun 20, 2012 at 12:15 PM, utsav <utsav.pshah@xxxxxxx> wrote: > Ya but when i use the return next it gives me all OUT parameters but i will > get last record of out parameter1 repetitive untill the last record of last > out parameter . Sorry i didn't have output with me . Is there any other way > to achive this ? > > Many Thanks for your help merlin ... right -- exactly. this is how set returning functions work. Each returned row contains both OUT variables. You can't return a set of parameter1 then swing around and return a set of parmameter2. If you want to return two independent sets, you are using the wrong mechanism. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
