From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | Matt Iskra <Matt(dot)Iskra(at)doj(dot)ca(dot)gov>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Trigger and Trigger function. |
Date: | 2005-06-17 13:54:22 |
Message-ID: | 237f689da37af1fb6d1502516658fabf@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
underscore.
dolq_start [A-Za-z\200-\377_]
dolq_cont [A-Za-z\200-\377_0-9]
dolqdelim \$({dolq_start}{dolq_cont}*)?\$
dolqinside [^$]+
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-06-17 13:56:29 | Re: multiple inserts |
Previous Message | Oren Mazor | 2005-06-17 13:32:21 | multiple inserts |