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

From: ow <oneway_111(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: A simple way to Create type ...?
Date: 2003-09-16 21:14:31
Message-ID: 20030916211431.66225.qmail@web21413.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- ow <oneway_111(at)yahoo(dot)com> wrote:
> Hi,
[...]
> How should one declare a new custom type, say, "AddressType" that corresponds
> internally to "varchar(50)". In other words, all columns that are assigned
> "AddressType" would internally be "varchar(50)".
>
> Example:
> create type AddressType ... -- how to do it in a simple way?

I guess, ideally it'd be
create type AddressType AS varchar(50) ;
but it does not work.

Any ideas? Thanks

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Browne 2003-09-16 21:27:13 Re: A simple way to Create type ...?
Previous Message ow 2003-09-16 21:04:36 A simple way to Create type ...?