| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: integer ceiling in LIMIT and OFFSET |
| Date: | 2003-10-22 12:34:56 |
| Message-ID: | 1066826095.3004.8.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 2003-10-22 at 04:01, Christopher Kings-Lynne wrote:
> Hi guys,
>
> What is the limit on the number of rows in a PostgreSQL table? If it's
> more than MAXINT, we have a problem:
>
> phppgadmin# select * from test limit 2147483648;
> ERROR: integer out of range
>
> Same problem with OFFSET.
I see you're point, but nobody is going to be interested in the first 2
billion rows of a table without using a cursor and having some other
process do the math in the background.
That said, perhaps the TODO for changing LIMIT / OFFSET to be expression
based should also mention bumping them to int8.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-10-22 13:28:42 | Re: So, are we going to bump catversion for beta5, or not? |
| Previous Message | Richard Huxton | 2003-10-22 10:55:55 | Re: So, are we going to bump catversion for beta5, or not? |