| 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: | Whole Thread | Raw Message | 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
| 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 |