From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: count() for a select statement? |
Date: | 2002-10-01 18:32:45 |
Message-ID: | 200210012032.45912.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tuesday 01 October 2002 07:46 pm, Jean-Christian Imbeault wrote:
> Is there an efficient way to get a count of the number of rows returned
> by this kind of query?
>
> select id from products where name ILIKE 'TNT' UNION select id from
> products where name ILIKE 'ATOM' UNION select id from products where
> name ILIKE 'BOB'
>
> I don't need any of the data returned, just a row count. The way I do it
> now is to execute the query and use (in PHP) pg_numrows() on the result
> set. But that mean the whole result set is being sent back to me when
> all I need is a count ...
>
> I've tried select count( select id from ...) but that didn't work ;)
>
You try :
select count(*)
from (select id from ...)
regards
haris peco
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2002-10-01 18:39:17 | Core Dump |
Previous Message | Adam Siegel | 2002-10-01 18:28:04 | Deletes from tables with foreign keys taking too long |