Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE TYPE VARCHAR2 - Mailing list pgsql-sql

From Tom Lane
Subject Re: CREATE TYPE VARCHAR2
Date
Msg-id 11065.1093486063@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TYPE VARCHAR2  (Sascha Ziemann <ziemann@secunet.de>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "David Price"
Date:
Subject: Optimizer Selecting Incorrect Index
Next
From: Tom Lane
Date:
Subject: Re: ERROR: Invalid regular expression: parentheses ( ) not balanced