Re: Connection string

On Sat, Aug 19, 2006 at 03:36:42PM +0200, Michael Meskes wrote:
> On Fri, Aug 18, 2006 at 02:54:19PM -0600, Michael Fuhr wrote:
> > It works with a double-quoted string but not with a single-quoted
> > string as the documentation mentions.
>
> It's not supposed to work with single-quoted strings. This is a
> documentation bug. Or does anyone think we should support single quotes
> too?

It doesn't matter to me; I'd just like to be sure the code is
behaving as expected (whatever "expected" is) before I submit a
documentation patch.

Here's an excerpt from 5WD-02-Foundation-2003-09.pdf, 17.1 <connect
statement>:

<connection target> ::=
<SQL-server name> [ AS <connection name> ] [ USER <connection user name> ]
| DEFAULT

Excerpt from 5.4 Names and identifiers:

<connection name> ::= <simple value specification>

<SQL-server name> ::= <simple value specification>

<connection user name> ::= <simple value specification>

Following along to 6.4 <value specification> and <target specification>
and 5.3 <literal> suggests that single-quoted strings should be
allowed. So far I haven't found anything to contradict that but I
could be overlooking or misinterpreting something.

--
Michael Fuhr