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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html