Re: constants in 2-column foreign keys or how to design a storage for text-groups ?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: constants in 2-column foreign keys or how to design a storage for text-groups ?
Date: 2009-12-11 08:39:47
Message-ID: hft0gj$2j5$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2009-12-09, Andreas <maps(dot)on(at)gmx(dot)net> wrote:
> Hi,

...
> stupid example:
> ---------------
> color: red, green, blue
> size: tiny, little, big, giant
> structure: hard, soft, floppy
>

> How would I solve the rather common text storage issue?

have you considered using enumerated types instead?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2009-12-11 08:48:33 Re: FIND_IN_SET
Previous Message Michael Eshom 2009-12-11 06:22:02 FIND_IN_SET