Postgres Pro
Downloads
Home   >   mailing lists

integer ceiling in LIMIT and OFFSET - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject integer ceiling in LIMIT and OFFSET
Date
Msg-id 3F963964.5090904@familyhealth.com.au
Whole thread Raw
Responses Re: integer ceiling in LIMIT and OFFSET
List pgsql-hackers
Tree view 
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.

Chris

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Timestamp docs weirdness
Next
From: Peter Eisentraut
Date:
Subject: Re: Timestamp docs weirdness