From: Gilles DAROLD <gilles@darold.net>
To: Simon Crute <simon-news@nospam.geordie.demon.co.uk>
Cc: pgsql-general@postgresql.org
Subject: Re: Re: case sensitivity
Date: Tue, 15 May 2001 00:49:12 +0200
Message-ID: <3B0060E8.EDCF98D7@darold.net> (raw)
References: <22535.989723392@sss.pgh.pa.us>
<989749499.4806.0.nnrp-08.9e981bad@news.demon.co.uk>
Simon Crute wrote:
> If anyone's interested,
> I found the answer to my first question buried in the DBI docs
> (fetch_hashref("NAME_uc") if anyone's interested)
>
> With regards to case
> > AFAIK we're exactly as picky about it as Oracle, just in the opposite
> > direction.
>
> I think there's some differences in function names. In oracle I think you
> can get away with count(), or COUNT(), in postgres it has to be COUNT(), but
> this was probably going through the perl DBI, so that may have been
> complicating things.
Oracle doesn't care about case sensitive in queries, Postgres too if you don't
quote tablename or columnname at creation time. If you use quote and upercase
at creation time you may quote it as well in you're queries. Function can be
lower
or upper case it doesn't matter at least in PostgreSQL 7.0.3.
SELECT COUNT(*) FROM "T_USERPREF";
select count(*) from "T_USERPREF";
Works well.
But you want columname returned as uppercase and you find the way...
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-general@postgresql.org
Cc: gilles@darold.net, simon-news@nospam.geordie.demon.co.uk
Subject: Re: Re: case sensitivity
In-Reply-To: <3B0060E8.EDCF98D7@darold.net>
* 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