Re: Trigger/Function problem
От | Robert B. Easter |
---|---|
Тема | Re: Trigger/Function problem |
Дата | |
Msg-id | 0012142110412B.00289@comptechnews обсуждение исходный текст |
Ответ на | Trigger/Function problem ("Dan Wilson" <phpPgAdmin@acucore.com>) |
Ответы |
Re: Trigger/Function problem
|
Список | pgsql-general |
On Thursday 14 December 2000 21:27, Dan Wilson wrote: > > I'm totally fine up to this point... then I try this: > > UPDATE help SET site_id = 'APW' WHERE help_id = 2; > > I get the following error: > > NOTICE: plpgsql: ERROR during compile of f_auto_date near line 1 > "RROR: parse error at or near " Try: UPDATE help SET site_id = ''APW'' WHERE help_id = 2; Remember that ' is used to enclose the whole function body. You have to use '' to mean a literal '. -- -------- Robert B. Easter reaster@comptechnews.com --------- - CompTechNews Message Board http://www.comptechnews.com/ - - CompTechServ Tech Services http://www.comptechserv.com/ - ---------- http://www.comptechnews.com/~reaster/ ------------
В списке pgsql-general по дате отправления: