Re: Factoring where clauses through UNIONS take 2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Factoring where clauses through UNIONS take 2
Date: 2003-04-25 03:57:16
Message-ID: 6055.1051243036@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathan Bartlett <johnnyb(at)eskimo(dot)com> writes:
> Does this apply to NULLs as well?

Yes, NULL literals are type UNKNOWN until proved otherwise.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2003-04-25 04:03:24 Re: [SQL] rewriting values with before trigger
Previous Message Jonathan Bartlett 2003-04-25 03:52:32 Re: Factoring where clauses through UNIONS take 2