Postgres Pro
Downloads
Home   >   mailing lists

Re: '' <> NULL - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: '' <> NULL
Date
Msg-id Pine.LNX.4.44.0303251720440.1651-100000@peter.localdomain
Whole thread Raw
In response to Re: '' <> NULL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: '' <> NULL  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
scott.marlowe writes:

> It is transform_null_equals.  Set it to true, shut down and restart your
> database, and
>
> 'select 1 where '' = NULL' should work.

No, transform_null_equals has nothing to do with this.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: '' <> NULL
Next
From: Dennis Gearon
Date:
Subject: Re: trigger question.