karly(at)kipshouse(dot)org writes:
> Yes, that's what I'm looking for. How can I create an IMPLICIT
> cast from date to my custom type? IOW, if I assing a date to a
> varible of my type, it will be converted to the format I specify.
Make a function that does the conversion the way you want, and then
create a cast that uses the function (see CREATE CAST).
regards, tom lane