From: | Michael Meskes <meskes(at)postgresql(dot)org> |
---|---|
To: | Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Case sensitivity issues |
Date: | 2000-02-07 06:48:53 |
Message-ID: | 20000207074853.A1134@fam-meskes.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Feb 06, 2000 at 10:51:34PM +0000, Emmanuel Charpentier wrote:
> I have lived that SQL database were not to be case-sensitive. However,
Which one? I have yet to work with one, that is unless you count Access as a
real database which it is not.
> This interface mostly works, but has some odd behaviour :
> /* Querying « usarrests » does ! Note that column names have been
> lowercased as well ... */
Sure. SQL is case insesitive by default. Quote your case-sensitive string
with double-quotes and it works.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(at)Fam-Meskes(dot)De | Use PostgreSQL!
From | Date | Subject | |
---|---|---|---|
Next Message | Ansley, Michael | 2000-02-07 07:42:13 | RE: [HACKERS] ONLY |
Previous Message | Timothy Dyck | 2000-02-07 06:41:26 | follow-up on PC Week Labs benchmark results |