Sascha Ziemann <ziemann@secunet.de> writes:
> I would like to define a
> new type VARCHAR2 which should behave exactly like VARCHAR.
You could get about halfway there with CREATE DOMAIN varchar2 AS varchar;
But it's only halfway because the domain will not accept length
decorations; that is "varchar2(100)" will not work.
regards, tom lane