X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E671E528AD for ; Thu, 30 Jun 2005 08:13:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90933-08 for ; Thu, 30 Jun 2005 11:12:59 +0000 (GMT) Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by svr1.postgresql.org (Postfix) with ESMTP id 892775285C for ; Thu, 30 Jun 2005 08:12:58 -0300 (ADT) Received: from bell.credativ.de (unknown [80.137.55.210]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 48789D7658; Thu, 30 Jun 2005 13:15:34 +0200 (CEST) From: Peter Eisentraut To: Tom Lane Subject: Re: ENUM like data type Date: Thu, 30 Jun 2005 13:13:05 +0200 User-Agent: KMail/1.8.1 Cc: Rod Taylor , =?iso-8859-1?q?Mart=EDn_Marqu=E9s?= , pgsql-sql@postgresql.org References: <200506292320.32726.peter_e@gmx.net> <29905.1120085759@sss.pgh.pa.us> In-Reply-To: <29905.1120085759@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200506301313.06054.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/372 X-Sequence-Number: 21973 Am Donnerstag, 30. Juni 2005 00:55 schrieb Tom Lane: > It's not that hard to make your own type using the builtin textin and > textout functions, and then add just the functions you wish to provide. Implementing the "distinct type" feature of SQL would probably amount to something like that. Might be worth looking into. -- Peter Eisentraut http://developer.postgresql.org/~petere/