Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group