| From: | Mark Jewiss <Mark(dot)Jewiss(at)knowledge(dot)com> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Limit rows |
| Date: | 1999-09-29 16:09:14 |
| Message-ID: | Pine.BSO.4.10.9909291706390.5608-100000@office.knowledge.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello,
On Wed, 29 Sep 1999, Oleg Bartunov wrote:
> select * from table limit 5,10;
Excellent, that works perfectly. I've done a grep over the html
documentation, and can't see anything regarding the limit feature (if I've
just missed it and it is there could someone provide a pointer please?).
I'm interested now in how this method actually works - is a query
performed that reads all of the rows of a table into memory, and then the
non-requested rows are discarded before the results are sent back?
I'm interested in how this would work with a massive table......
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart Rison | 1999-09-29 16:21:39 | Re: [SQL] Limit rows |
| Previous Message | Oleg Bartunov | 1999-09-29 15:56:36 | Re: [SQL] Limit rows |