integer ceiling in LIMIT and OFFSET

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: integer ceiling in LIMIT and OFFSET
Date: 2003-10-22 08:01:40
Message-ID: 3F963964.5090904@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-10-22 08:12:11 Re: Timestamp docs weirdness
Previous Message Christopher Kings-Lynne 2003-10-22 07:39:11 Re: [HACKERS] obj_description problems?