Postgres Pro
Downloads
Home   >   mailing lists

Re: Null comparisons and the transform_null_equals run-time parameter - Mailing list pgsql-general

From Tom Lane
Subject Re: Null comparisons and the transform_null_equals run-time parameter
Date
Msg-id 4405.1275745274@sss.pgh.pa.us
Whole thread Raw
In response to Null comparisons and the transform_null_equals run-time parameter  ("Ken Winter" <ken@sunward.org>)
Responses Re: Null comparisons and the transform_null_equals run-time parameter  ("Ken Winter" <ken@sunward.org>)
List pgsql-general
Tree view 
"Ken Winter" <ken@sunward.org> writes:
> When the run-time parameter transform_null_equals is on, shouldn't two
> variables with NULL values evaluate as equal?

No.  That setting does not change the runtime behavior of comparison.
The only thing it does is change the literal syntax "something = NULL"
to "something IS NULL".

            regards, tom lane

pgsql-general by date:

Previous
From: Manohar Bhattarai
Date:
Subject: Re: [ADMIN] Exception while accessing database
Next
From: "Wang, Mary Y"
Date:
Subject: Re: ERROR: character 0x90 of encoding "WIN1252" has no equivalent in "UTF8"