Re: Query about SQL in PostgreSQL - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Query about SQL in PostgreSQL
Date
Msg-id 20050419132547.GA21284@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Query about SQL in PostgreSQL  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-sql
On Tue, Apr 19, 2005 at 11:59:58AM +0200, KÖPFERL Robert wrote:
> Postgres has the weird behavour to compare identifies case sensitive BUT to
> downcast any non-quoted identifier inside an SQL statement. 
> So it is reccomended to just use lower case (for readability) 

Or never double-quote identifiers.  I sort of don't believe exactly
the original poster's report, however, because the error message
wasn't right no matter what.  I'd like to see a real session
transcript.  Also, this probably belongs on -general.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.    --Bruce Schneier


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: can a function return a virtual table?
Next
From: Stephan Szabo
Date:
Subject: Re: "Money" Data Type Problem