From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
---|---|
To: | 'Patrick Hatcher' <PHatcher(at)macys(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: escape character in a function |
Date: | 2002-04-24 10:05:30 |
Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F7485F@MAIL_EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Try doubleing the apostraphe again, ie:
set div_name = ''RICH''''S''
Cheers,
- Stuart
> -----Original Message-----
> From: Patrick Hatcher [mailto:PHatcher(at)macys(dot)com]
> Sent: 23 April 2002 22:26
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] escape character in a function
>
>
> Howdy
> How do I do an escape character in a function to for a word
> that has an
> apostrophe like: RICH'S. I tried ''RICH\'S'', but when I run
> my function,
> I get back mismatch parentheses.
> TIA
>
> REATE FUNCTION "sp_updaterlg"() RETURNS "int4" AS '
> begin
> update bcp_cust
> set div_name = ''RICH\'S''
> where
> div_store is not null
> and instr(div_store,''RICH\'S'',1) >0;
>
> return 1;
> end;
> ' LANGUAGE 'plpgsql';
>
> Patrick Hatcher
> Macys.Com
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Torbj=?ISO-8859-1?B?9g==?=rn Andersson | 2002-04-24 14:46:32 | pg_setlocale() |
Previous Message | Henshall, Stuart - WCP | 2002-04-24 10:03:18 | Re: Storing .jpg files |