| 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? |