| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: To Postgres Devs : Wouldn't changing the select limit |
| Date: | 2001-10-20 03:44:44 |
| Message-ID: | 11415.1003549484@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> One more thing. I have added the code to suggest alternate syntax for
> LIMIT #,#:
> test=> select * from pg_class LIMIT 1,1;
> ERROR: LIMIT #,# syntax no longer supported. Use LIMIT # OFFSET #.
If you're going to do that, *please* suggest the *correct* substitution.
AFAICT, our version of LIMIT m,n transposes to OFFSET m LIMIT n; but
your message suggests the opposite.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-10-20 04:54:41 | Re: To Postgres Devs : Wouldn't changing the select limit |
| Previous Message | Bruce Momjian | 2001-10-20 02:51:15 | Re: To Postgres Devs : Wouldn't changing the select limit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2001-10-20 04:22:30 | Re: Catalogs design question |
| Previous Message | Steve Howe | 2001-10-20 03:39:59 | Catalogs design question |