aggregate functions, COUNT - Mailing list pgsql-sql

From Kevin Way
Subject aggregate functions, COUNT
Date
Msg-id 20011002161121.A8772@bean.overtone.org
Whole thread Raw
Responses Re: aggregate functions, COUNT  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: faster and faster!!
Next
From: Stephan Szabo
Date:
Subject: Re: Question about indexing!