GREAT!!! Just "offset 0" in the subquery did the trick! I had already been playing with a stored proc, but that's way more messy than this.
Thanks a million! Peter -----Original Message----- From: Adam Rich [mailto:[EMAIL PROTECTED] Sent: 30 May 2008 17:14 To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Subject: RE: [GENERAL] The optimizer is too smart for me - How can I trick it? > 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
