On Tue, Dec 8, 2009 at 3:51 PM, Scott Marlowe <[email protected]> wrote: > On Tue, Dec 8, 2009 at 12:12 PM, Allan Kamau <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
