Re: where is this problem (trigger)

On Wed, 12 May 2004, Theodore Petrosky wrote:

> I can not seem to update these rows because of the dot
> in the jobnumber field. I have found that I can change
> the dot to an underscore but I thought I would ask if
> there is a better solution.
>
> here is the error:
>
> UPDATE jobinfo SET isbilled = false WHERE jobnumber =
> '1162.01';
> ERROR: syntax error at or near ".01" at character 20
> CONTEXT: PL/pgSQL function "notify_jobinfo" line 2 at
> execute statement

From the docs, it looks like NOTIFY takes an identifier
as a name. Foo_1023.01 is not a valid identifier so you
might want to double quote the string since "Foo_1023.01"
is one.