On Mon, Sep 25, 2006 at 14:59:46 +0200,
Harald Armin Massa <[EMAIL PROTECTED]> wrote:
> Asaf,
>
> SQL-92 states that identifiers [for dictionary objects] are limited to 128
> characters and are case-insensitive (unless delimited by double quotes),
> because they are automatically translated into
Asaf,SQL-92 states that identifiers [for dictionary
objects] are limited to 128 characters and are case-insensitive (unless delimited
by double quotes), because they are automatically translated into uppercase
by the system.Standards are SQL-92, SQL-99 and SQL-2003, done by ISO and other standardiz
Asaf,this is not a bug. To use identifier names (identfiers = column-names, table-names, view-names...) with capital and small characters, you need to doublequote those names.So you can do select "Asaf" from "Avraham"
but not select Asaf from Avraham. This behaviour is documented and intended.Best
Asaf,
quote them and it will work.
Richard
On Sun, 24 Sep 2006, Asaf Avraham wrote:
> Date: Sun, 24 Sep 2006 06:18:38 GMT
> From: Asaf Avraham <[EMAIL PROTECTED]>
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] BUG #2648: I can not create table name with capital and
>
The following bug has been logged online:
Bug reference: 2648
Logged by: Asaf Avraham
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4.2
Operating system: win
Description:I can not create table name with capital and small
characters
Details:
I have table t
