Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 3B34D633D5B
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  8 Apr 2009 16:42:33 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 18376-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  8 Apr 2009 16:42:28 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by mail.postgresql.org (Postfix) with SMTP id 51DE4633D1F
	for <pgsql-sql@postgresql.org>; Wed,  8 Apr 2009 16:42:30 -0300 (ADT)
Received: (qmail invoked by alias); 08 Apr 2009 19:42:28 -0000
Received: from a91-154-107-53.elisa-laajakaista.fi (EHLO vanquo.pezone.net)
	[91.154.107.53]
	by mail.gmx.net (mp023) with SMTP; 08 Apr 2009 21:42:28 +0200
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX196pvxFU0d6QtfihNU2j0sNkxzJiNZBnUYFG4S081
	+aP3W8S+wRnKBE
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: ENUM vs DOMAIN vs FKyed loookup table
Date: Wed, 8 Apr 2009 22:42:25 +0300
User-Agent: KMail/1.11.2 (Linux/2.6.26-1-686; KDE/4.2.2; i686; ; )
Cc: Mario Splivalo <mario.splivalo@megafon.hr>
References: <49DCDA27.4090901@megafon.hr>
In-Reply-To: <49DCDA27.4090901@megafon.hr>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200904082242.26507.peter_e@gmx.net>
X-Y-GMX-Trusted: 0
X-FuHaFi: 0.71
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.174 tagged_above=0 required=5 tests=AWL=0.174
X-Spam-Level: 
X-Archive-Number: 200904/45
X-Sequence-Number: 32391

On Wednesday 08 April 2009 20:08:55 Mario Splivalo wrote:
> What are your practices, when do you use ENUMs and when Domains?

When given the choice, pretty much ENUMs.  Domains weren't really conceived 
for this sort of thing in the first place, so it's good to move away from 
them.