That's exactly it - thanks, works perfectly now!
For the record, it's 8.0.3
Dmitri
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 06, 2005 12:32 PM
> To: Dmitri Bichko
> Cc: pgsql-sql@postgresql.org
> Subject: Re
"Dmitri Bichko" <[EMAIL PROTECTED]> writes:
> Ok, I'm thoroughly confused.
You didn't say which PG version you are using, but if it's something
reasonably recent then it should be able to push upper qual conditions
down into a UNION. I think you are getting bit by this restriction:
* 3. For sub
Ok, I'm thoroughly confused.
Simple query:
tb3=> explain analyze select bin, alias as symbol from alias_hs a join
bin_hs using (id,source) where upper(alias) like 'PPARG';
QUERY PLAN
