differnce from ansi sql standard - unicode strings?
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
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> ]
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> ]