Re: [BUGS] BUG #8141: multi-column check expression evaluating to NULL

2013-05-08 Thread Gavin Flower
On 09/05/13 01:07, andras.va...@zalando.de wrote: The following bug has been logged on the website: Bug reference: 8141 Logged by: Andras Vaczi Email address: andras.va...@zalando.de PostgreSQL version: 9.1.9 Operating system: linux/Ubuntu 12.10 Description: Consider the fo

Re: [BUGS] BUG #8141: multi-column check expression evaluating to NULL

2013-05-08 Thread Tom Lane
andras.va...@zalando.de writes: > Consider the following table with a CHECK constraint: > CREATE TABLE check_test > ( > id integer NOT NULL, > col integer, > CONSTRAINT unique_with_null_check1 CHECK (col >= 1 AND id < 20) > ); > This INSERT statement succeeds: > INSERT INTO check_test (id,