Wm.A.Stafford wrote:
I'm trying to use a temporary sequence to duplicate the functionality
of the Oracle rownum pseudo-column
as suggested by Scott Marlow in the archives:
http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php.
The Oracle based application I'm porting to PostgreSQL used
"Wm.A.Stafford" <[EMAIL PROTECTED]> writes:
> ... is there a standard PostgreSQL way to select a
> 'block' of rows from a result set based on row number?
LIMIT/OFFSET might be what you are looking for --- it's certainly far
less klugy than a temporary sequence.
regards, t
I'm trying to use a temporary sequence to duplicate the functionality of
the Oracle rownum pseudo-column
as suggested by Scott Marlow in the archives:
http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php.
The Oracle based application I'm porting to PostgreSQL used rownum to
select th
