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
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 |