Re: Trying to add a type modifier to user created type

Yeb Havinga <yebhavinga@gmail.com> writes:
> Carsten Kropf wrote:
>> I wanted to add a new type that supports modifiers (comparable to
>> numeric/varchar).

> You need to add a cast from the type to itself, e.g.

The CREATE CAST reference page has the gory details here.

            regards, tom lane