Postgres Pro
Downloads
Home   >   mailing lists

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

From Filip Rembiałkowski
Subject Re: short-cutting if sum()>constant
Date
Msg-id 92869e660912220548j43a4528fu28b1389477e9fb1c@mail.gmail.com
Whole thread Raw
In response to short-cutting if sum()>constant  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: short-cutting if sum()>constant  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-sql
Tree view


2009/12/22 Ivan Sergio Borgonovo <mail@webthatworks.it>
Hi,

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?


With plain SQL, no.

With a user defined function in PL/PgSQL, yes.

 


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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/

pgsql-sql by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: short-cutting if sum()>constant
Next
From: Adam Tauno Williams
Date:
Subject: Re: short-cutting if sum()>constant