On Wed, 9 Jan 2002, Mike Hoolehan wrote:
> Please enter a FULL description of your problem:
>
> if a quoted column alias in a FROM clause sub-select contains upper-case
> chars, then that column cannot be later referenced without using quotes
>
> P
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',
Mike Hoolehan writes:
> if a quoted column alias in a FROM clause sub-select contains upper-case
> chars, then that column cannot be later referenced without using quotes
This is expected behaviour. See also
http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/sql-syntax.html#SQL-SYNTAX
POSTGRESQL BUG REPORT TEMPLATE
Your name : Mike Hoolehan
Your email address : [EMAIL PROTECTED]
