<div class="Section1"><p class="MsoNormal">hi when i execute the following script using pgadmin query tool:<p
class="MsoNormal"> <pclass="MsoNormal">windows xp, sp2<p class="MsoNormal">pgadmin 1.8.2 as installed whith postgres
binary8.3.1<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">--------------------------------<pclass="MsoNormal"> <p class="MsoNormal">CREATE DOMAIN "dt_0" AS
varchar(32)<pclass="MsoNormal"> NULL;<p class="MsoNormal"> <p class="MsoNormal">CREATE DOMAIN "dt_1" AS
varchar<pclass="MsoNormal"> NULL;<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">CREATEFUNCTION "x1" (IN name dt_0, IN description dt_1)<p class="MsoNormal">RETURNS integer <p
class="MsoNormal">AS$$<p class="MsoNormal">SELECT 0;<p class="MsoNormal">$$<p class="MsoNormal">LANGUAGE SQL<p
class="MsoNormal">IMMUTABLE<pclass="MsoNormal">RETURNS NULL ON NULL INPUT;<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">---------------------------<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">wheni look at the function definition using pgadmin it looks like this:<p class="MsoNormal"> <p
class="MsoNormal">--Function: x1(dt_0(36), dt_1)<p class="MsoNormal"> <p class="MsoNormal">-- DROP FUNCTION
x1(dt_0(36),dt_1);<p class="MsoNormal"> <p class="MsoNormal">CREATE OR REPLACE FUNCTION x1("name" dt_0(36), description
dt_1)<pclass="MsoNormal"> RETURNS integer AS<p class="MsoNormal">$BODY$<p class="MsoNormal">SELECT 0;<p
class="MsoNormal">$BODY$<pclass="MsoNormal"> LANGUAGE 'sql' IMMUTABLE STRICT<p class="MsoNormal"> COST 100;<p
class="MsoNormal">ALTERFUNCTION x1(dt_0(36), dt_1) OWNER TO postgres;<p class="MsoNormal"> <p
class="MsoNormal">--------------------------<pclass="MsoNormal"> <p class="MsoNormal">if i try to delete it: i get:<p
class="MsoNormal"> <pclass="MsoNormal">an error has occured: tyep modifier is not allowed for type "dt_0"<p
class="MsoNormal"> <pclass="MsoNormal">why is the (36) there????<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">regards<pclass="MsoNormal"> </div>