Try doubleing the apostraphe again, ie:
set div_name = ''RICH''''S''
Cheers,
- Stuart
> -----Original Message-----
> From: Patrick Hatcher [mailto:PHatcher@macys.com]
> Sent: 23 April 2002 22:26
> To: pgsql-novice@postgresql.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
>
