Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug in check constraint? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in check constraint?
Date
Msg-id 18999.1105903907@sss.pgh.pa.us
Whole thread Raw
In response to Bug in check constraint?  ("Luiz Gonzaga da Mata" <gonzaga@pbh.gov.br>)
Responses Re: Bug in check constraint?  ("Luiz Gonzaga da Mata" <gonzaga@pbh.gov.br>)
List pgsql-bugs
Tree view 
"Luiz Gonzaga da Mata" <gonzaga@pbh.gov.br> writes:
> Sees, below, that it seems to have one bug in set transform_null_equals
> or, then, in <> NULL.

transform_null_equals only catches the exact syntax "something = NULL".
It does not touch "something <> NULL".  The latter is always going to
yield NULL, by definition.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Luiz Gonzaga da Mata"
Date:
Subject: Bug in check constraint?
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever