[Rt-devel] Searchbuilder 1.24 + postgres + quoted identifiers = boom

Andrew Sullivan ajs at crankycanuck.ca
Sat Apr 9 12:13:55 EDT 2005

On Fri, Apr 08, 2005 at 07:08:45PM -0400, David Kerry wrote:
> (other databases too, probably).  Normally (as far as I'm aware,
> anyways), most databases treat column names as case-independent,
> *unless* you go to the trouble of quoting them *everywhere*.

Right.  That's actually the SQL spec: everything's supposed to be
uppercase-folded unless you double-quote the identifiers.  Postgres
folds to lower case for backward compatibility (and partly on
usability grounds).

Andrew Sullivan  | ajs at crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
		--George Orwell

More information about the Rt-devel mailing list