| From: | Klaus Reger <K(dot)Reger(at)wwwdb(dot)de> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Repost: Get table/field-identifiers in uppercase |
| Date: | 2001-07-10 05:01:23 |
| Message-ID: | 200107100501.f6A51c916087@pc01.reger-clan.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
because no one noticed my last question, please forgive me this repost, but I
promised my boss to get an answer to this questions.
Here they are:
When a new table or field is created without quotes, it is assumed to be
case-insensitive. Herefore I have some questions:
- Is it SQL-92-conform to handle >"test"< like >test< without quotes, or
shouldn't it be >test< forced to lowercase?
- Oracle returns this no_matter_what-case_it_is-fields with
uppercase-letters. Is it possible for Postgresql, to imitate this behaviour?
- How is the handling of case-sensitivity handled in the system-catalogs? Is
ther any flag or depends it on the name of the object only?
Thank you very much in advance!
Klaus
--
Visit WWWdb at
http://wwwdb.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harry Yau | 2001-07-10 09:14:55 | Quick Question! |
| Previous Message | Rachit Siamwalla | 2001-07-10 04:30:38 | WaitOnLock: error on wakeup |