On Fri, Sep 07, 2007 at 11:36:23AM +0200, M. van Egmond wrote: > Hello everybody, > > Im having troubles overriding postgresql's default behaviour of throwing > an error while trying to cast an empty string to int4. I would like to > cast empty strings to a null integer value. I've tried this by creating > my own domain:
Your problem is that ''::myint does not call your cast function, it calls the input function for your basetype, which a domain can't override. Your options are to actually make a new basetype, which isn't too hard. Or, you can use ''::text::myint which probably will call your cast function. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
