Mike Hoolehan <mike(at)sycamorehq(dot)com> 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
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Peter Eisentraut||Date: 2002-01-09 19:42:36|
|Subject: Re: case-sensitivity inconsistency in quoted column aliases|
|Previous:||From: Bruno Wolff III||Date: 2002-01-09 17:29:28|
|Subject: 'natural join' and 'join ... using' giving different results|