On Tue, Dec 8, 2009 at 3:51 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> On Tue, Dec 8, 2009 at 12:12 PM, Allan Kamau <kamauallan@xxxxxxxxx> wrote:
>> Hi,
>> I did follow the basic advise and consulted the documentation for
>> "SELECT" and came across "[ FETCH { FIRST | NEXT } [ count ] { ROW |
>> ROWS } ONLY]" clause which seems to satisfy my requirement.
>
> This is a cursor,
no. this is sql 2008 syntax for the LIMIT clause:
http://www.postgresql.org/docs/8.4/static/sql-select.html#SQL-LIMIT
> which is one of two very basic ways of doing this.
i agree, that using cursor is another (preferred?) solution for this,
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
