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