On Wed, Oct 15, 2008 at 10:21 PM, A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx> wrote: > > Can you show an example for 8.4? I looked for ROW_NUMBER in the developer docs. I could only find it under the KEY WORDS list. I guess they haven't put in a good example yet. I saw this recently demonstrated at PgWest by Dave Fetter. He illustrated several example of how to use analytic functions such as these. http://fetter.org/Window_Functions_WEST_2008.pdf http://fetter.org/Trees_and_More_WEST_2008.pdf -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general