From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com> |
Cc: | David Johnston <polobo(at)yahoo(dot)com>, Dave Cramer <pg(at)fastcrypt(dot)com>, GEISINGER Marc - Contractor <Marc(dot)GEISINGER(at)external(dot)thalesgroup(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting? |
Date: | 2012-09-24 18:33:47 |
Message-ID: | 20516.1348511627@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com> writes:
> On Mon, Sep 24, 2012 at 6:54 AM, David Johnston <polobo(at)yahoo(dot)com> wrote:
>> Is there any SQL syntax that allows for a dollar-sign outside of a string
>> literal? If not then if we are not in a string and we encounter a
>> dollar-sign we could assume that we are dealing with a PostgreSQL string and
>> immediately return the original input unchanged.
> Identifiers can also contain "$" when quoted:
Identifiers can contain "$" even when not quoted ...
regression=# create table foo$ (bar$ int);
CREATE TABLE
I don't think that's per SQL spec, but PG allows it, mainly because some
other databases do.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2012-09-24 18:43:40 | Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting? |
Previous Message | the6campbells | 2012-09-24 17:49:46 | Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions? |