Re: Trigger/Function problem - Mailing list pgsql-general

From Robert B. Easter
Subject Re: Trigger/Function problem
Date
Msg-id 0012142117492C.00289@comptechnews
Whole thread Raw
In response to Re: Trigger/Function problem  ("Robert B. Easter" <reaster@comptechnews.com>)
List 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 by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: Trigger/Function problem
Next
From: "Dan Wilson"
Date:
Subject: Re: Trigger/Function problem