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', etc). > I assume this is a bug, since if the column is aliases as "foo" (with > quotes, all lowercase), then the column can later be referenced > without quotes with case-insensitivity.
This is not a bug, it's the expected behavior. See the discussion of identifier case sensitivity in the manual, eg http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
