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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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