Count and Results together

From: "Jan Sunavec" <jan(dot)sunavec(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Count and Results together
Date: 2005-05-18 07:07:13
Message-ID: op.sqyl2buoc8yns6@akela-mobile
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Samer Abukhait 2005-05-18 07:07:55 Executing Dynamic DDL
Previous Message Richard Huxton 2005-05-18 07:05:59 Re: Logs