Column name case conversion

From: Zeljko Trogrlic <zeljko(at)post(dot)hinet(dot)hr>
To: pgsql-general(at)postgresql(dot)org
Subject: Column name case conversion
Date: 2000-09-04 12:26:33
Message-ID: 4.1.20000904142252.0184d320@pop.tel.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Column names are behaving very strangely. In queries, all names are
converted to lowercase.

Example:

I have a table named "LOCATION".
When I try
select * from location;
I get an error message (this is OK)
When I try
select * from LOCATION;
I get an error message (this is NOT OK)
When I try
select * from "LOCATION";
I get an error message (this is OK)

Is it by design? I think that database shouldn't convert name case in SQL
statements, or it should try to make case-insensitive match (like
Interbase) if double quotes are not used.
v
Zeljko Trogrlic
____________________________________________________________

Aeris d.o.o.
Sv. Petka 60 b, HR-31000 Osijek, Croatia
Tel: +385 (31) 53 00 15
Email: mailto:zeljko(at)post(dot)hinet(dot)hr

Browse pgsql-general by date

  From Date Subject
Next Message Gilles DAROLD 2000-09-04 12:29:33 Re: PL/Perl compilation error
Previous Message Oliver Smith 2000-09-04 12:14:31 That killer 3rd join...