Re: A simple way to Create type ...?

From: John DeSoi <jd(at)icx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: A simple way to Create type ...?
Date: 2003-09-17 02:39:04
Message-ID: 1A568736-E8B8-11D7-87CD-0030656EE7B2@icx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Kuria 2003-09-17 08:18:27 sub query
Previous Message ow 2003-09-16 22:13:11 Re: A simple way to Create type ...?