Postgres Pro
Downloads
Home   >   mailing lists

loading only few rows from huge table - Mailing list pgsql-general

From Mark
Subject loading only few rows from huge table
Date
Msg-id 20041222193159.35734.qmail@web40906.mail.yahoo.com
Whole thread Raw
Responses Re: loading only few rows from huge table
List pgsql-general
Tree view 
Hi,
I have a table with 100K rows. One of columns is a timestamp and
indicates when this row inserted.

What will the the best way of getting 10 latest rows from that table
and  introducing partial data retrieval (rows 50-60, 100- 120, etc)

Thanks,
Mark.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

pgsql-general by date:

Previous
From: Ernest Kim
Date:
Subject: Re: BTree max row size?
Next
From: nico@def2shoot.com (Nicolas COUSSEMACQ)
Date:
Subject: 8.0 Beta3 worked, RC1 didn't!