[Rt-devel] Searchbuilder 1.24 + postgres + quoted identifiers =
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
Andrew Sullivan | ajs at crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
More information about the Rt-devel