Re: Count and Results together

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