loading only few rows from huge table

From: Mark <sendmailtomark(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: loading only few rows from huge table
Date: 2004-12-22 19:31:59
Message-ID: 20041222193159.35734.qmail@web40906.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Cunningham 2004-12-22 19:36:59 Re: postgresql.conf
Previous Message Sander Steffann 2004-12-22 19:30:40 Re: default index created for primary key