> I've implemented Depesz's running total function > (http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative- > sum-in- > one-query/) in my DB, which works great. > Now what I want to do is get the running total for a certain statement > and > then do a subselect on that result so to get a non-zero start on a > function. > > Instead, the optimizer sees what I'm trying to do, moves the where > clause > inside the subquery and my output becomes > > What can I do to tell the optimizer to keep its hands off my query or > at > least get it to not optimize? >
I think if you add a LIMIT/OFFSET clause to your subquery, the planner will leave it alone. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
