Skip site navigation (1) Skip section navigation (2)

Re: Unexpected Result in Windowing

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Unexpected Result in Windowing
Date: 2009-03-31 05:16:15
Message-ID: 200903310116.15530.xzilla@users.sourceforge.net (view raw or flat)
Thread:
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(at)fetter(dot)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

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2009-03-31 05:19:57
Subject: Re: 8.3.5: Crash in CountActiveBackends() - lockless race?
Previous:From: Robert TreatDate: 2009-03-31 05:14:16
Subject: Re: psql \d* and system objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group