Postgres Pro
Downloads
Home   >   mailing lists

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

From Jasen Betts
Subject Re: constants in 2-column foreign keys or how to design a storage for text-groups ?
Date
Msg-id hft0gj$2j5$1@reversiblemaps.ath.cx
Whole thread Raw
In response to constants in 2-column foreign keys or how to design a storage for text-groups ?  (Andreas <maps.on@gmx.net>)
Responses Re: Re: constants in 2-column foreign keys or how to design a storage for text-groups ?  (Andreas <maps.on@gmx.net>)
List pgsql-sql
Tree view 
On 2009-12-09, Andreas <maps.on@gmx.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?

pgsql-sql by date:

Previous
From: Michael Eshom
Date:
Subject: FIND_IN_SET
Next
From: Pavel Stehule
Date:
Subject: Re: FIND_IN_SET