Re: Trigger/Function problem

From: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
To: "Dan Wilson" <phpPgAdmin(at)acucore(dot)com>, "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger/Function problem
Date: 2000-12-15 02:17:49
Message-ID: 0012142117492C.00289@comptechnews
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)comptechnews(dot)com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Wilson 2000-12-15 02:27:11 Trigger/Function problem
Previous Message Robert B. Easter 2000-12-15 02:10:41 Re: Trigger/Function problem