Re: Count and Results together

Поиск
Список
Период
Сортировка
От Jan Sunavec
Тема Re: Count and Results together
Дата
Msg-id op.sq0gbbkec8yns6@akela-mobile
обсуждение исходный текст
Ответ на Re: Count and Results together  (Sean Davis <sdavis2@mail.nih.gov>)
Ответы Re: Count and Results together  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Count and Results together  (Dawid Kuroczko <qnex42@gmail.com>)
Список pgsql-general
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?

    JOhn

On Wed, 18 May 2005 17:37:09 +0200, Sean Davis <sdavis2@mail.nih.gov>
wrote:

>
> On May 18, 2005, at 3:07 AM, Jan Sunavec wrote:
>
>> Hi
>>
>> Is possible use SELECT NUM_ROWS, a, b, c FROM blabla WHERE x =id; I
>> mean it's much more faster than
>>
>>
>> SELECT a, b, c FROM blabla WHERE x =id; and then
>> SELECT count(*) FROM blabla WHERE x =id;
>
> Can you do this on the client side?  What client/interface are you using?
>
> There is a nice archive of the postgres mailing lists here:
> http://archives.postgresql.org/
>
> A quick search for ranks (not exactly what you want, but I think it has
> a useable solution in one of the posts) gets:
> http://archives.postgresql.org/pgsql-general/2005-05/msg00157.php
>
>



В списке pgsql-general по дате отправления:

Предыдущее
От: James Croft
Дата:
Сообщение: CREATE TABLE problem in plpgsql trigger
Следующее
От: Mark Steckel
Дата:
Сообщение: Postgres in government