count() for a select statement?

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема count() for a select statement?
Дата
Msg-id 3D99DF6E.6090009@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: count() for a select statement?
Re: count() for a select statement?
Список pgsql-general
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 ;)

Jc


В списке pgsql-general по дате отправления:

Предыдущее
От: "Johnson, Shaunn"
Дата:
Сообщение: execute transaction / insert rows
Следующее
От: Neil Conway
Дата:
Сообщение: Re: cluster replication with intermezzo