How to release SET() in PgSQL? - Mailing list pgsql-general

From Dan Lyke
Subject How to release SET() in PgSQL?
Date
Msg-id 14995.59646.338703.981051@wynand.flutterby.com
Whole thread Raw
In response to How to release SET() in PgSQL?  ("Andrey Y. Mosienko" <feo@ttn.ru>)
Responses Re: How to release SET() in PgSQL?
List pgsql-general
Andrey Y. Mosienko writes:
>  SELECT * FROM test WHERE a like 'one,three';
>
> How can I do it in PgSQL? I need it so much!

It isn't quite as clean, but in the long term I think it's a better
solution:

Use a join to another table with your "SET"/"ENUM" list in it.

Dan

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: vacuum analyze again...
Next
From: "And. Andruikhanov"
Date:
Subject: ELOG_TIMESTAMPS feature