Jeff Zucker wrote:
There is no database independent way to match a delimited identifier to an undelimited identifier.That part of my previous post is correct, but my examples were bad. Here is a better explanation with examples from two differing implementations:
In the ANSI standard, a delimited identifier is equal to an undelimited identifier if it matches *case-sensitively* to the *upper-cased* undelimited identifier.
In PostgreSQL, a delimited identifier is equal to an undelimited identifier if it matches *case-sensitively* to the *lower-cased* undelimited identifier.
In ODBC, a delimited identifier is equal to an undelimited identifiers if it matches *case-insenitively*.
Foo = "FOO" (in ANSI and ODBC but not in PG)
Foo = "foo" (in PG and ODBC but not in ANSI)
Foo = "Foo" (in ODBC but not in PG or ANSI)
--
Jeff
