Re: equivalent of mysql's SET type?

From: Reece Hart <reece(at)harts(dot)net>
To: Steve Atkins <steve(at)blighty(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: equivalent of mysql's SET type?
Date: 2011-03-09 04:54:52
Message-ID: AANLkTikZOc3beRj-RCTeenrJesMkysj_0TRueq1_WOuv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 8, 2011 at 5:51 PM, Steve Atkins <steve(at)blighty(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Darren Duncan 2011-03-09 05:27:50 Re: equivalent of mysql's SET type?
Previous Message Reece Hart 2011-03-09 04:48:44 Re: equivalent of mysql's SET type?