Re: CREATE TYPE VARCHAR2

Re: CREATE TYPE VARCHAR2

am 26.08.2004 04:07:43 von tgl

Sascha Ziemann 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend