Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexpected Result in Windowing - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Unexpected Result in Windowing
Date
Msg-id 20183.1238434283@sss.pgh.pa.us
Whole thread Raw
In response to Unexpected Result in Windowing  (David Fetter <david@fetter.org>)
Responses Re: Unexpected Result in Windowing  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view 
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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: More message encoding woes
Next
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] New shapshot RPMs (Mar 27, 2009) are ready for testing