Postgres Pro
Downloads
Home   >   mailing lists

Re: Factoring where clauses through UNIONS take 2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Factoring where clauses through UNIONS take 2
Date
Msg-id 6055.1051243036@sss.pgh.pa.us
Whole thread Raw
In response to Re: Factoring where clauses through UNIONS take 2  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
Tree view 
Jonathan Bartlett <johnnyb@eskimo.com> writes:
> Does this apply to NULLs as well?

Yes, NULL literals are type UNKNOWN until proved otherwise.

            regards, tom lane

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Factoring where clauses through UNIONS take 2
Next
From: Robert Treat
Date:
Subject: Re: [SQL] rewriting values with before trigger