Horton

Re: Unexpected Result in Windowing

Robert Treat <xzilla@users.sourceforge.net>

View thread View on postgr.es
From: Robert Treat <xzilla@users.sourceforge.net>
To: pgsql-hackers@postgresql.org
Cc: David Fetter <david@fetter.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2009-03-31T05:16:15Z
Lists: pgsql-hackers 
On Monday 30 March 2009 15:34:49 David Fetter wrote:
> On Mon, Mar 30, 2009 at 01:31:23PM -0400, Tom Lane wrote:
> > David Fetter <david@fetter.org> writes:
> > > SELECT
> > >     i,
> > >     t,
> > >     RANK() OVER (
> > >         PARTITION BY i
> > >         ORDER BY random()
> > >     )
> > > FROM foo;
> > > ERROR:  ORDER/GROUP BY expression not found in targetlist
> >
> > Fixed.
>
> Thanks! :)
>

Yes, thanks!

-- 
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com