Right so the parser basically has to look for $<optionalstring>$ in
order to determine if it is in dollar quoting. As David Johnstone
mentioned this is not part of the JDBC spec and would have an impact
on all queries. I'm not getting terribly motivated to implement this.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 24, 2012 at 2:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Maciek Sakrejda <m.sakrejda@gmail.com> writes:
>> On Mon, Sep 24, 2012 at 6:54 AM, David Johnston <polobo@yahoo.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