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 4E142D1B4EB for ; Tue, 16 Sep 2003 21:47:22 +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 53124-08 for ; Tue, 16 Sep 2003 18:46:51 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id A4AB3D1B4EF for ; Tue, 16 Sep 2003 18:46:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id E3E991025A; Tue, 16 Sep 2003 17:38:26 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-150.tor.dsl.tht.net [134.22.133.150]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 9BCDF10248; Tue, 16 Sep 2003 17:38:24 -0400 (EDT) Subject: Re: A simple way to Create type ...? From: Rod Taylor To: ow Cc: pgsql-sql@postgresql.org In-Reply-To: <20030916211431.66225.qmail@web21413.mail.yahoo.com> References: <20030916211431.66225.qmail@web21413.mail.yahoo.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-fd6gZz94vyEyCiR8dj3h" Message-Id: <1063748843.26265.1.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Tue, 16 Sep 2003 17:47:23 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/142 X-Sequence-Number: 15120 --=-fd6gZz94vyEyCiR8dj3h Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > I guess, ideally it'd be > create type AddressType AS varchar(50) ; > but it does not work. Only one keyword off. SQL calls this a domain. They're limited in 7.3, but much improved (not yet perfect) for 7.4. http://www.postgresql.org/docs/7.3/interactive/sql-createdomain.html --=-fd6gZz94vyEyCiR8dj3h Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/Z4Tq6DETLow6vwwRAq0zAJ45iRrUag7QDHqE7WFqUukBTy9r5wCfX3Uk gE55ouBnFRZSZ98nFLli+yc= =iuPW -----END PGP SIGNATURE----- --=-fd6gZz94vyEyCiR8dj3h--