Re: ENUM vs DOMAIN vs FKyed loookup table

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
Subject: Re: ENUM vs DOMAIN vs FKyed loookup table
Date: 2009-04-08 19:42:25
Message-ID: 200904082242.26507.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kashmir 2009-04-08 20:17:21 join help
Previous Message Mario Splivalo 2009-04-08 17:08:55 ENUM vs DOMAIN vs FKyed loookup table