Postgres Pro
Downloads
Home   >   mailing lists

short-cutting if sum()>constant - Mailing list pgsql-sql

From Ivan Sergio Borgonovo
Subject short-cutting if sum()>constant
Date
Msg-id 20091222133527.3007bd96@dawn.webthatworks.it
Whole thread Raw
Responses Re: short-cutting if sum()>constant  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Re: short-cutting if sum()>constant  (Adam Tauno Williams <awilliam@opengroupware.us>)
Re: short-cutting if sum()>constant  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: short-cutting if sum()>constant  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
Tree view 
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?


-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: 8.4.1 distinct query WITHOUT order by
Next
From: Filip Rembiałkowski
Date:
Subject: Re: short-cutting if sum()>constant