Re: equivalent of mysql's SET type?
От
Reece Hart
Тема
Re: equivalent of mysql's SET type?
Дата
Msg-id
AANLkTikZOc3beRj-RCTeenrJesMkysj_0TRueq1_WOuv@mail.gmail.com
Ответ на
Re: equivalent of mysql's SET type? (Steve Atkins)
Список
Дерево обсуждения
equivalent of mysql's SET type? Reece Hart <reece@harts.net>
Re: equivalent of mysql's SET type? Darren Duncan <darren@darrenduncan.net>
Re: equivalent of mysql's SET type? Reece Hart <reece@harts.net>
Re: equivalent of mysql's SET type? Darren Duncan <darren@darrenduncan.net>
Re: equivalent of mysql's SET type? John R Pierce <pierce@hogranch.com>
Re: equivalent of mysql's SET type? Reece Hart <reece@harts.net>
Re: equivalent of mysql's SET type? Merlin Moncure <mmoncure@gmail.com>
Re: equivalent of mysql's SET type? Reece Hart <reece@harts.net>
Re: equivalent of mysql's SET type? Merlin Moncure <mmoncure@gmail.com>
Re: equivalent of mysql's SET type? Merlin Moncure <mmoncure@gmail.com>
Re: equivalent of mysql's SET type? Dmitriy Igrishin <dmitigr@gmail.com>
Re: equivalent of mysql's SET type? Merlin Moncure <mmoncure@gmail.com>
Re: equivalent of mysql's SET type? Dmitriy Igrishin <dmitigr@gmail.com>
Re: equivalent of mysql's SET type? Merlin Moncure <mmoncure@gmail.com>
Re: equivalent of mysql's SET type? Steve Atkins <steve@blighty.com>
Re: equivalent of mysql's SET type? Reece Hart <reece@harts.net>
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 по дате отправления
