Re: [SQL] Limit rows - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] Limit rows
Date
Msg-id 199909291719.NAA03431@candle.pha.pa.us
Whole thread Raw
In response to Limit rows  (Mark Jewiss <Mark.Jewiss@knowledge.com>)
List pgsql-sql
> Hello,
> 
> I'm still thinking about ways to extract specific rows of data from a
> table, whilst ignoring others. i.e. I want to see rows 3-7 inclusive from
> a table.

SELECT * FROM table LIMIT 4 OFFSET 3

Should be in 6.5.*.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Clayton Cottingham
Date:
Subject: Re: [SQL] How about a postgreSQL cookbook? (was [SQL] Subselect performance)
Next
From: "Ismail Kizir"
Date:
Subject: PL/PgSql documentation and examples