On Jun 17, 2005, at 8:59 AM, Michael Fuhr wrote:
>> I don't think $upd_last_touch$ is a legal dollar quote. It needs to be
>> alphanumeric characters only (no underscores).
> Eh? Works here in 8.0.3, at least in psql:
Hmm, sorry I don't know what I did the first time. I pasted the code
(removing the annotation) and executed it. I got an "unterminated
dollar quote" error. I changed them to '$$' and then it worked. I must
have had some other stray change that I missed.
For the record, here is the dollar quote format - alphanumeric plus
John DeSoi, Ph.D.
Power Tools for PostgreSQL
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-06-17 13:56:29|
|Subject: Re: multiple inserts|
|Previous:||From: Oren Mazor||Date: 2005-06-17 13:32:21|
|Subject: multiple inserts|