A simple way to Create type ...?

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

Hi,

I had a look at "create type" docs and it seems somewhat complex, involving
creation of functions and etc. I hope there's a simpler way for the following:

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?

create table ADDRESS
{
address_id int not null,
street_address1 AdressType not null,
street_address2 AdressType not null,
....
)

Thanks

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ow 2003-09-16 21:14:31 Re: A simple way to Create type ...?
Previous Message Jagdeesh 2003-09-16 19:49:02 Array fields in Postgresql...