Re: Null comparisons and the transform_null_equals run-time parameter

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ken Winter" <ken(at)sunward(dot)org>
Cc: "'PostgreSQL pg-general List'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Null comparisons and the transform_null_equals run-time parameter
Date: 2010-06-05 13:41:14
Message-ID: 4405.1275745274@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ken Winter" <ken(at)sunward(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wang, Mary Y 2010-06-05 14:07:35 Re: ERROR: character 0x90 of encoding "WIN1252" has no equivalent in "UTF8"
Previous Message Manohar Bhattarai 2010-06-05 11:34:07 Re: Exception while accessing database