Re: equivalent of mysql's SET type? - Mailing list pgsql-general

From Reece Hart
Subject Re: equivalent of mysql's SET type?
Date
Msg-id AANLkTikZOc3beRj-RCTeenrJesMkysj_0TRueq1_WOuv@mail.gmail.com
Whole thread Raw
In response to Re: equivalent of mysql's SET type?  (Steve Atkins <steve@blighty.com>)
List pgsql-general
On Tue, Mar 8, 2011 at 5:51 PM, Steve Atkins <steve@blighty.com> wrote:
tsvector or intarray might be other options, depending on how you're going to query it and whether those are really strings or more enum-ish.

The more SQLy way of doing it would be to have that stored in a separate table, with a foreign key to this one.

Using a separate table is what I've got now in an experimental conversion. This works well enough and might save me the bother of an enum update. Perhaps I should just move on.

Thanks Steve.

-Reece

pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: Re: equivalent of mysql's SET type?
Next
From: Darren Duncan
Date:
Subject: Re: equivalent of mysql's SET type?