Could someone tell me what is wrong withthis function

From: <tsmets(at)brutele(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Could someone tell me what is wrong withthis function
Date: 2002-03-25 14:36:27
Message-ID: 044801c1d40a$74cdf260$6501a8c0@calvin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This is almost a copy / paste from Bruce Momjian's book :
<snip>
create function trigger_iso_code_2_uppercase()
returns opaque
as 'BEGIN
if new.countrycode !~''^[A-Za-z][A-Za-z]$''
then raise exception ''ISO-code are excepted to be uppercase
letters.'';
ENd if;
new.countrycode=upper(new.countrycode);
new.countryname=initcap(new.countryname);
end;'
language 'internal';
</snip>

but I get the following :

<snip>
ERROR: ProcedureCreate: there is no builtin function named "BEGIN
if new.countrycode !~'^[A-Za-z][A-Za-z]$'
then raise exception 'ISO-code are excepted to be uppercase
letters.';
ENd if;
new.countrycode=upper(new.countrycode);
new.countryname=initcap(new.countryname);
end;"
</snip>

Please note that I logging as postgres

tx for your help,

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PGMailList 2002-03-25 15:06:26 Re: Could someone tell me what is wrong withthis function
Previous Message tsmets 2002-03-25 12:21:13 rule problem