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

Re: where is this problem (trigger)

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
Cc: postgres SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: where is this problem (trigger)
Date: 2004-05-14 15:06:31
Message-ID: 20040514080501.M35179@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-sql
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.


In response to

Responses

pgsql-sql by date

Next:From: Christoph HallerDate: 2004-05-14 16:44:39
Subject: Re: where is this problem (trigger)
Previous:From: Greg StarkDate: 2004-05-14 05:40:26
Subject: Re: Multiple outer join on same table

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