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.
signature.asc
Description: This is a digitally signed message part
