Thread: differnce from ansi sql standard - unicode strings?

differnce from ansi sql standard - unicode strings?

From
Pavel Stehule
Date:
Hello

I found BNF for SQL 2003 and I found there some small difference.
Standard use keyword ESCAPE, but PostgreSQL use keybord UESCAPE.

Anybody knows reason?
 <Unicode character string literal>    ::=        [ <introducer> <character set specification> ]        U <ampersand>
<quote>[ <Unicode representation> ... ] <quote>        [ { <separator> <quote> [ <Unicode representation> ... ] <quote>
}...]        [ ESCAPE <escape character> ]
 

thank you
Pavel Stehule


Re: differnce from ansi sql standard - unicode strings?

From
Peter Eisentraut
Date:
Pavel Stehule wrote:
> I found BNF for SQL 2003 and I found there some small difference.
> Standard use keyword ESCAPE, but PostgreSQL use keybord UESCAPE.
> 
> Anybody knows reason?
> 
>   <Unicode character string literal>    ::=
>          [ <introducer> <character set specification> ]
>          U <ampersand> <quote> [ <Unicode representation> ... ] <quote>
>          [ { <separator> <quote> [ <Unicode representation> ... ] <quote> }... ]
>          [ ESCAPE <escape character> ]

My copy has

<Unicode character string literal> ::=
[ <introducer><character set specification> ]
U<ampersand><quote> [ <Unicode representation>... ] <quote>
[ { <separator> <quote> [ <Unicode representation>... ] <quote> }... ]
<Unicode escape specifier>

<Unicode escape specifier> ::= [ UESCAPE <quote><Unicode escape 
character><quote> ]


Re: differnce from ansi sql standard - unicode strings?

From
Pavel Stehule
Date:
Hi,

It's possible - I used unofficial BNF graph from internet.

so problem is on my side.

thank you
Pavel


2009/2/17 Peter Eisentraut <peter_e@gmx.net>:
> Pavel Stehule wrote:
>>
>> I found BNF for SQL 2003 and I found there some small difference.
>> Standard use keyword ESCAPE, but PostgreSQL use keybord UESCAPE.
>>
>> Anybody knows reason?
>>
>>  <Unicode character string literal>    ::=
>>         [ <introducer> <character set specification> ]
>>         U <ampersand> <quote> [ <Unicode representation> ... ] <quote>
>>         [ { <separator> <quote> [ <Unicode representation> ... ] <quote>
>> }... ]
>>         [ ESCAPE <escape character> ]
>
> My copy has
>
> <Unicode character string literal> ::=
> [ <introducer><character set specification> ]
> U<ampersand><quote> [ <Unicode representation>... ] <quote>
> [ { <separator> <quote> [ <Unicode representation>... ] <quote> }... ]
> <Unicode escape specifier>
>
> <Unicode escape specifier> ::= [ UESCAPE <quote><Unicode escape
> character><quote> ]
>