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 WHER

[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 expec