| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Rod Taylor <rbt(at)rbt(dot)ca>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: integer ceiling in LIMIT and OFFSET |
| Date: | 2003-10-22 16:08:23 |
| Message-ID: | Pine.LNX.4.33.0310221006480.12830-100000@css120.ihs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 22 Oct 2003, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > That said, perhaps the TODO for changing LIMIT / OFFSET to be expression
> > based should also mention bumping them to int8.
>
> Can't get excited about it ... this would slow down the normal use of
> the facility for what seems a completely hypothetical need.
While I'm pretty sure
select * from sometable limit 2147483648
isn't gonna be common, maybe someone would be likely to do something like:
select * from sometable limit 10 offset 2147483648
I wouldn't do it, but who knows what shadows lurk in men's minds?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2003-10-22 16:10:21 | Re: Last beta ... we hope? |
| Previous Message | Neil Conway | 2003-10-22 16:08:14 | Re: Last beta ... we hope? |