On Fri, Oct 16, 2009 at 01:28:57PM -0400, Tom Lane wrote: > David Fetter <[email protected]> writes: > > I think what the OP was expecting was to have the last value be 3 > > instead of changing. This is at least a POLA violation. > > [ shrug... ] It's what the spec requires, as far as anybody here > can tell. As Hitoshi-san already noted, we do point out in our docs > that last_value is not too useful unless you use a nondefault window > frame selection. I'm not sure what else we could do.
Perhaps an illustration of the issue and a workaround in the docs? Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
