On Fri, Jan 16, 2009 at 12:23:16PM -0500, Jaime Casanova wrote: > On Fri, Jan 16, 2009 at 12:07 PM, David Fetter <da...@fetter.org> wrote: > >> > >> Now i want only 3 records for every typ: > >> > >> test=# select typ, ts, rank() over (partition by typ order by ts desc ) > >> from foo where rank <= 3; > >> ERROR: column "rank" does not exist > >> LINE 1: ...rtition by typ order by ts desc ) from foo where rank <= 3; > > maybe the rank should go in a having clause? i'm not familiar about > window functions yet... just guessing...
I tried HAVING, too, and it's epic fail. :( > > ERROR: syntax error at or near "WHERE" > > LINE 8: WHERE > > ^ > > the WINDOW specification goes after the WHERE clause not before Thanks :) Still remaining is our inability to limit windowing functions other than via subselect or equivalently CTEs. I believe this is a bug. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
