| From: | manisha balwadkar <manisha_balwadkar(at)yahoo(dot)co(dot)in> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Stored Procedure with more than one OUT Parameter |
| Date: | 2006-11-20 14:03:05 |
| Message-ID: | 20061120140305.47253.qmail@web8801.mail.in.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello,
I have written a stored procedure which will give me
total count of records plus number of records as per
my conditional criteria, but returns as setof records.
So to access count i have to iterate through
resultset, in java. So is there any way, to access
count once n setof records using resultset. Can I have
two OUT parameter, one as Integer n other as record in
single procedure.
Or at java side, can acces count before iterating
resultset only once. Remaining records as usual by
iterating resuleset.
Thanx,
Manisha
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-11-20 20:33:33 | Re: xlog lockup patch (was: BUG #2712: could not fsync |
| Previous Message | S.Balaji | 2006-11-20 12:07:25 | BUG #2772: Undefined Subroutine Pg::connectdb (" "); |