On Tue, 2009-12-22 at 13:35 +0100, Ivan Sergio Borgonovo wrote: > Hi, > I'd like to know if > select sum(qty) from t where status=37; > is > constant. > qty is always >0. > Is there a way to skip examining further rows and return a result > ASAP?
SELECT SUM(object_version) FROM date_x WHERE owner_id = 10100 HAVING SUM(object_version) > 1000 ? -- OpenGroupware developer: awill...@whitemice.org <http://whitemiceconsulting.blogspot.com/> OpenGroupare & Cyrus IMAPd documenation @ <http://docs.opengroupware.org/Members/whitemice/wmogag/file_view> -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
