Re: A simple way to Create type ...? - Mailing list pgsql-sql

On Tuesday, September 16, 2003, at 05:27 PM, Christopher Browne wrote:

> What you want instead is CREATE DOMAIN.
>
> flexreg=# create domain addresstype varchar(50);


The problem here is that you can't tell the difference between a 
addresstype column and a varchar(50) column in the row description 
information returned by SELECT. All columns just look like varchar(50). 
It would be nice if there was something as easy as CREATE DOMAIN but 
worked more like CREATE TYPE.

Best,

John DeSoi, Ph.D.