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

Tue, 10 Jul 2001 07:01:23 +0200
Klaus Reger <K.Reger@wwwdb.de>
Repost: Get table/field-identifiers in uppercase