Re: Query about SQL in PostgreSQL

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(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier