[HACKERS] default lower case of identifier

2006-07-26 Thread jkzhao



Dear hackers,

 I am migrating an application program 
fromOracle to PostgreSQL, but one problem blocks me.

 According to SQL92 standard, in 
Oracle, identifiersthat are not double quoted are changed to upper 
case.

 But, in PostgreSQL, 
identifiersthat are not double quoted are changed to lower 
case.

 So,create user "HU", 
thenconnectOracle byHUis right;

 But, create user "HU" then 
connectPostgreSQL by HU is wrong.

 My application program is very long 
and hasmany such errors.

 I'd like to know whether I can make 
PostgreSQL stands to the SQL92 standard bychanging somePostgreSQL's 
code?

 Thanks  Best 
Regards.



JK. zhao
2006-07-26


Re: [HACKERS] default lower case of identifier

2006-07-26 Thread Qingqing Zhou

jkzhao [EMAIL PROTECTED] wrote

 But, create user HU then connect PostgreSQL by HU is wrong.


If you do

postgres=# create user HU;

You will get the HU as you want. Usage of the quotation marks is in the
manual.


 I'd like to know whether I can make PostgreSQL stands to the SQL92
 standard by changing some PostgreSQL's code?


Just cite Tom's post:

The difference between what PG does and what the spec says can only be
observed when you sometimes double-quote a particular identifier and
sometimes don't.  PG makes FOO, Foo, foo and foo the same, but
different from FOO or Foo; while the spec would have FOO, Foo, foo
and FOO the same but different from foo or Foo.

PostgreSQL is almost there and most of the problem is on the client side.

Regards,
Qingqing




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match