Re: Count and Results together

On 5/19/05, Dawid Kuroczko <qnex42(at)gmail(dot)com> wrote:
> On 5/19/05, Jan Sunavec <jan(dot)sunavec(at)gmail(dot)com> wrote:
> > I am using libpg.so. I tryed find solution for this problem in internet
> > but, I don't find nothing yet. I have idea get rowcount throught some
> > function write in C. Or is there any plan add this feature into PostgreSQL?
> Theoretically you could declare a cursor, count the rows (from plpgsql
> preferably, to avoid sending all the data to the client), rewind the
> cursor (MOVE) and return it. The problem is that I think it is not possible
> for PL/pgsql to return both integer (row count) and a cursor (for the
> query rewound) at the same time...

I stand corrected. GET DIAGNOSTICS, PQntuples(), etc. are the way
to do it.

Regards,
Dawid