Skip site navigation (1) Skip section navigation (2)

escape character in a function

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: escape character in a function
Date: 2002-04-23 21:25:42
Message-ID: OF42F17F60.601FBF55-ON88256BA4.0074D9F1@fds.com (view raw or flat)
Thread:
Lists: pgsql-novice
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



pgsql-novice by date

Next:From: Joshua b. JoreDate: 2002-04-23 22:03:32
Subject: Re: INSERT results
Previous:From: Joshua b. JoreDate: 2002-04-23 21:24:50
Subject: Re: Storing .jpg files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group