Re: CREATE TYPE VARCHAR2

Sascha Ziemann <ziemann [at] 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
tgl [ Do, 26 August 2004 04:07 ] [ ID #453400 ]
Datenbanken » comp.databases.postgresql.sql » Re: CREATE TYPE VARCHAR2

Vorheriges Thema: ERROR: Invalid regular expression: parentheses ( ) not balanced
Nächstes Thema: PQexec and SPI_exec