Re: [GENERAL] Count and Results together

[Jan Sunavec]

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 <[EMAIL PROTECTED]>  
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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match