Re: Trigger/Function problem
От | Robert B. Easter |
---|---|
Тема | Re: Trigger/Function problem |
Дата | |
Msg-id | 0012142117492C.00289@comptechnews обсуждение исходный текст |
Ответ на | Re: Trigger/Function problem ("Robert B. Easter" <reaster@comptechnews.com>) |
Список | pgsql-general |
On Thursday 14 December 2000 21:10, Robert B. Easter wrote: > 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 '. Nevermind. I should have looked more closely at the message. %-) -- -------- 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 по дате отправления: