From: Qingqing Zhou <zhouqq@cs.toronto.edu>
To: pgsql-hackers@postgresql.org
Subject: Re: default lower case of identifier
Date: Thu, 27 Jul 2006 09:28:12 +0800
Message-ID: <ea94vf$sgr$1@news.hub.org> (raw)
References: <200607261549343289047@pku.edu.cn>
""jkzhao"" <jkzhao@pku.edu.cn> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: zhouqq@cs.toronto.edu
Subject: Re: default lower case of identifier
In-Reply-To: <ea94vf$sgr$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox