From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Query about SQL in PostgreSQL
Date: Tue, 19 Apr 2005 09:25:47 -0400
Message-ID: <20050419132547.GA21284@phlogiston.dyndns.org> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB166BE@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB166BE@neptun.sonorys.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Query about SQL in PostgreSQL
In-Reply-To: <20050419132547.GA21284@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox