differnce from ansi sql standard - unicode strings?

Started by Pavel Stehulealmost 17 years ago3 messages
#1Pavel Stehule
pavel.stehule@gmail.com

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Pavel Stehule (#1)
Re: differnce from ansi sql standard - unicode strings?

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> ]

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Peter Eisentraut (#2)
Re: differnce from ansi sql standard - unicode strings?

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>:

Show quoted text

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> ]