On Sun, Oct 16, 2005 at 11:03:52AM +0200, Sim Zacks wrote: > create function uint_in(val cstring) returns uint2 as > $$ > declare thisval int4; > begin > thisval=val::int4 > if thisval between 0 and 65535 then > return (thisval-32768)::int2; > else > return 0; > end if; > end > $$ language 'plpgsql';
On a side note, do you really want to punt to 0 when an invalid value comes it? That sounds like something MySQL would do... ISTM you should throw an error. Also, you could have written that as a pure SQL function, which would have been faster (assuming you could use something other than C for this). -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
