Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group