From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Connection string |
Date: | 2006-08-19 14:34:32 |
Message-ID: | 20060819143432.GA90402@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John Gunther | 2006-08-19 15:40:39 | Confused about locales |
Previous Message | Tom Lane | 2006-08-19 14:02:28 | Re: Arrays and backslashes |