aggregate functions, COUNT

Поиск
Список
Период
Сортировка
От Kevin Way
Тема aggregate functions, COUNT
Дата
Msg-id 20011002161121.A8772@bean.overtone.org
обсуждение исходный текст
Ответы Re: aggregate functions, COUNT  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
I'm currently using a SELECT count(*) when all I really want to know is
if 1 or more records exist.  Is there a standard way to just find out if
a record exists?  If not, is there a way to avoid iterating over all the
records by writing an aggregate function?  Given what I've read of how
they work, I don't see how to make the function return before parsing
all the results anyway, am I wrong here?

Thanks for any help, or 2x4s,
Kevin Way

-- 
Kevin Way <kevin.way@overtone.org>
http://www.overtone.org/


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: faster and faster!!
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Question about indexing!