Re: CREATE TYPE VARCHAR2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sascha Ziemann <ziemann(at)secunet(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: CREATE TYPE VARCHAR2
Date: 2004-08-26 02:07:43
Message-ID: 11065.1093486063@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Sascha Ziemann <ziemann(at)secunet(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-08-26 02:21:30 Re: ERROR: Invalid regular expression: parentheses ( ) not balanced
Previous Message Andrew Perrin 2004-08-25 18:20:52 Re: Complicated "group by" question