[BUGS] BUG #6673: Value out of range for type integer when adding WHERE clause

2012-06-02 Thread mfork00
The following bug has been logged on the website: Bug reference: 6673 Logged by: Michael Fork Email address: mfor...@yahoo.com PostgreSQL version: 9.1.3 Operating system: Scientific Linux release 6.2 (Carbon) Description: The following query and plan executes as

Re: [BUGS] BUG #6673: Value out of range for type integer when adding WHERE clause

2012-06-02 Thread Tom Lane
mfor...@yahoo.com writes: However, the following query, which is just the above query with 'WHERE card.id IS NULL' tacked on to the end fails with an integer out of range. Important to know is that parsecardidfromreferencecode will return a valid integer ONLY for the rows matching the WHERE