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/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org