From: | Dawid Kuroczko <qnex42(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Count and Results together |
Date: | 2005-05-19 16:03:09 |
Message-ID: | 758d5e7f05051909035d5f73aa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Berend Tober | 2005-05-19 16:03:18 | Re: Preserving data after updates |
Previous Message | Berend Tober | 2005-05-19 15:59:24 | Re: Postgres in government |