case-sensitivity inconsistency in quoted column aliases in FROM subselects

From: Mike Hoolehan <mike(at)sycamorehq(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: case-sensitivity inconsistency in quoted column aliases in FROM subselects
Date: 2002-01-09 16:42:45
Message-ID: 20020109114245.A21074@sycamorehq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Mike Hoolehan
Your email address : mike(at)sycamorehq(dot)com

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium

Operating System (example: Linux 2.0.26 ELF) : RH 7.2, Kernel 2.4.9-13

PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3

Compiler used (example: gcc 2.95.2) : gcc 2.96 (rpm version)

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

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
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.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2002-01-09 17:29:28 'natural join' and 'join ... using' giving different results
Previous Message Tim Nelson 2002-01-09 16:16:43 Re: ecpg "aborts" on structure reference