Re: custom type similar to varchar(#) - Mailing list pgsql-general

From Tom Lane
Subject Re: custom type similar to varchar(#)
Date
Msg-id 14717.1028318082@sss.pgh.pa.us
Whole thread Raw
In response to custom type similar to varchar(#)  (Jeff Davis <list-pgsql-general@empires.org>)
List pgsql-general
Jeff Davis <list-pgsql-general@empires.org> writes:
> I would like to try to emulate the behavior of the old style varchar(#), in
> which it automatically truncated values that were oversized. To do this, it
> occured to me to try making a custom type, but for that I would need to
> accept the numerical argument as part of the type. I could not find any way
> in the documentation to create such a type.

varchar and other types with special syntax require special processing
in the parser.  If you're not afraid of yacc grammars then you could
hack up gram.y to add another special type name.  On the whole, though,
you might prefer to go and revert the change in the varchar limit-check
routine ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR
Next
From: Doug McNaught
Date:
Subject: Re: How i can empty the buffers of a db