I fire this trigger whenever my client updates a row
in the db:
CREATE FUNCTION notify_jobinfo() RETURNS "trigger"
EXECUTE ''NOTIFY ''||TG_RELNAME||''_''||NEW.jobnumber;
CREATE TRIGGER notify_jobinfo
AFTER UPDATE ON jobinfo
FOR EACH ROW
EXECUTE PROCEDURE notify_jobinfo();
CREATE TABLE jobinfo (
jobnumber text DEFAULT
creationdate date DEFAULT now(),
iscomplete boolean DEFAULT false,
isbilled boolean DEFAULT false,
CONSTRAINT "$1" CHECK ((jobnumber <> ''::text))
My problem is that I have had to import legacy data
for the jobnumber column. My client was originally
using an excel file. they were free to do as they
pleased and there are jobnumbers like '1041.01'
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 =
ERROR: syntax error at or near ".01" at character 20
CONTEXT: PL/pgSQL function "notify_jobinfo" line 2 at
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
pgsql-sql by date
|Next:||From: Bruno Wolff III||Date: 2004-05-12 18:16:20|
|Subject: Re: How do i extract a certain bit from a bigint column|
|Previous:||From: Gary Stainburn||Date: 2004-05-12 14:06:35|
|Subject: solved Re: view problem - too many rows out|