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
Re: Count and Results together |
Список | 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 по дате отправления: