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:
---------------------------------------------------------------------
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 |