Re: dollar quoting nits

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: dollar quoting nits
Date: 2004-02-24 16:16:30
Message-ID: 22787.1077639390@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> 1. Is there any reason to exclude underscore as the first char of a
> dollar quoting delimiter (after the $), e.g. $_foo_$? I'm happy either
> way, just want to be as liberal as is reasonable.

I think we had agreed to "same rules as identifiers, except for $".

> 2. David Fetter asked me the other day if there was any limit on the
> length of the foo inside the $foo$. I glibly told him that I thought
> that we should treat it the same as identifiers, but I have pretty much
> convinced myself that this is wrong.

I agree, there is no reason to truncate.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen 2004-02-24 16:43:52 Avoid MVCC using exclusive lock possible?
Previous Message Jonathan M. Gardner 2004-02-24 16:11:03 Materialized View Summary