Re: [GENERAL] Window function order changing order of whole query

2009-10-12 Thread Martijn van Oosterhout
On Mon, Oct 12, 2009 at 09:13:09AM +0100, Thom Brown wrote: > I tried posting this on the pgsql-sql but they don't seem to be posting > successfully there, so I'm re-posting it here. > > I've had a look at examples of lag and lead window functions with order by > inside the OVER clause, and I'm co

[GENERAL] Window function order changing order of whole query

2009-10-12 Thread Thom Brown
I tried posting this on the pgsql-sql but they don't seem to be posting successfully there, so I'm re-posting it here. I've had a look at examples of lag and lead window functions with order by inside the OVER clause, and I'm confused as to why it influences the overall order in the output. For e