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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]