Skip site navigation (1) Skip section navigation (2)

Re: Trigger and Trigger function.

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-06-17 13:56:29
Subject: Re: multiple inserts
Previous:From: Oren MazorDate: 2005-06-17 13:32:21
Subject: multiple inserts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group