X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D724ED1B50F for ; Tue, 16 Sep 2003 21:15:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 45862-07 for ; Tue, 16 Sep 2003 18:14:32 -0300 (ADT) Received: from web21413.mail.yahoo.com (web21413.mail.yahoo.com [216.136.232.184]) by svr1.postgresql.org (Postfix) with SMTP id 50923D1B4FC for ; Tue, 16 Sep 2003 18:14:30 -0300 (ADT) Message-ID: <20030916211431.66225.qmail@web21413.mail.yahoo.com> Received: from [64.81.205.234] by web21413.mail.yahoo.com via HTTP; Tue, 16 Sep 2003 14:14:31 PDT Date: Tue, 16 Sep 2003 14:14:31 -0700 (PDT) From: ow Subject: Re: A simple way to Create type ...? To: pgsql-sql@postgresql.org In-Reply-To: <20030916210436.81214.qmail@web21409.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/141 X-Sequence-Number: 15119 --- ow 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