Re: [BUGS] case-sensitivity inconsistency in quoted column aliases in FROM subselects

2002-01-09 Thread Tom Lane
Mike Hoolehan <[EMAIL PROTECTED]> writes: > SELECT * FROM (SELECT col1 as "Foo" from table1) AS innerQuery > WHERE Foo = 'whatever'; > results in > "ERROR: Attribute 'foo' not found" > no matter what capitalization is used for "Foo" in the where clause > (i.e. foo='whatever', FOO='whatever',

[BUGS] case-sensitivity inconsistency in quoted column aliases in FROM subselects

2002-01-09 Thread Mike Hoolehan
POSTGRESQL BUG REPORT TEMPLATE Your name : Mike Hoolehan Your email address : [EMAIL PROTECTED]