On Mon, Mar 30, 2009 at 01:31:23PM -0400, Tom Lane wrote: > David Fetter <[email protected]> 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! :) Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
