Postgres Pro
Downloads
Home   >   mailing lists

default lower case of identifier - Mailing list pgsql-hackers

From jkzhao
Subject default lower case of identifier
Date
Msg-id 200607261549343289047@pku.edu.cn
Whole thread Raw
List pgsql-hackers
Tree view
Dear hackers,
 
    I am migrating an application program from Oracle to PostgreSQL, but one problem blocks me.
 
    According to SQL92 standard, in Oracle, identifiers that are not double quoted are changed to upper case.
 
    But, in PostgreSQL, identifiers that are not double quoted are changed to lower case.
 
    So, create user "HU", then connect Oracle by  HU  is right;
 
    But, create user "HU" then connect PostgreSQL by HU is wrong.
 
    My application program is very long and has many such errors.
 
    I'd like to know whether I can make PostgreSQL stands to the SQL92 standard by changing some PostgreSQL's code?
 
    Thanks & Best Regards.
JK. zhao
2006-07-26

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: On-disk bitmap index patch
Next
From: Greg Stark
Date:
Subject: Re: Better name/syntax for "online" index creation