Count and Results together - Mailing list pgsql-general

From Jan Sunavec
Subject Count and Results together
Date
Msg-id op.sqyl2buoc8yns6@akela-mobile
Whole thread Raw
Responses Re: Count and Results together
List pgsql-general
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;

     John

pgsql-general by date:

Previous
From: Justin Tocci
Date:
Subject: TABLEs to VIEWs with Perl
Next
From: Hugo
Date:
Subject: Newbie question