Re: Type cast text to int4

Could you please give me the correct syntax to create a basetype using
pl/pgsql functions instead of external functions?
Or is this impossible?

Thanks.

Martijn van Oosterhout schreef:
> 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,
>