From: Stefan Becker <pgsql@yukonho.de>
To: pgsql-sql@postgresql.org
Subject: Re: ROW_NUMBER alias
Date: Sun, 6 May 2007 20:41:30 +0200
Message-ID: <200705062041.31192.pgsql@yukonho.de> (raw)
In-Reply-To: <36af4bed0705060901s36fed269ye5a8588eaffbd750@mail.gmail.com>
References: <36af4bed0705060901s36fed269ye5a8588eaffbd750@mail.gmail.com>
I might be told off by some better SQL-User here on the list -
still here is my 2 Cents worth....
> I needed ROW_NUMBER() in PostGresql and I did find the 'temporary sequence'
> method as a workaround and i think it at least gets the job done relatively
you use:
> CREATE TEMP SEQUENCE rownum;
> SELECT nextval('rownum') AS row_number , t.a, t.b, t.c
> FROM (
> SELECT a, b, c
> FROM table
> WHERE table_id = 973
> ORDER BY record_date
> ) t;
Doesn't this just return the 973th single record for the current
sequence order in your table?
I believe:
SELECT a, b, c FROM table
offset 973 limit 1
will accomplish the same result.
Stefan
--
email: stefan@yukonho.de
tel : +49 (0)6232-497631
http://www.yukonho.de
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgsql@yukonho.de
Subject: Re: ROW_NUMBER alias
In-Reply-To: <200705062041.31192.pgsql@yukonho.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox