Re: Bug in check constraint?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Luiz Gonzaga da Mata" <gonzaga(at)pbh(dot)gov(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in check constraint?
Date: 2005-01-16 19:31:47
Message-ID: 18999.1105903907@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Luiz Gonzaga da Mata" <gonzaga(at)pbh(dot)gov(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-01-16 19:38:25 Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever
Previous Message Chris Jones 2005-01-16 16:15:55 Re: BUG #1397: busy-loop hang on web server