2009/12/22 Ivan Sergio Borgonovo <[email protected]> > 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Filip Rembiałkowski JID,mailto:[email protected] http://filip.rembialkowski.net/
