| 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:10:41 |
| Message-ID: | 0012142110412B.00289@comptechnews |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)comptechnews(dot)com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert B. Easter | 2000-12-15 02:17:49 | Re: Trigger/Function problem |
| Previous Message | Sandeep Joshi | 2000-12-15 01:26:21 | create trigger : functions |