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

From Andrey Y. Mosienko
Subject How to release SET() in PgSQL?
Date
Msg-id 3A9380EF.838126EE@ttn.ru
Whole thread Raw
Responses How to release SET() in PgSQL?
Re: How to release SET() in PgSQL?
List pgsql-general
Hello All!


I used MySQL for a long time. There is SET() conception.
I can define SET('one','two','three') and use that type:

CREATE TABLE "test" (
    "a" SET('one','two','three')
};

And then:

 SELECT * FROM test WHERE a = 'one';
or
 SELECT * FROM test WHERE a like 'one,three';

How can I do it in PgSQL? I need it so much!


--
with respection Andrey Feofilactovich.
e-mail: feo@ttn.ru, feo@feo.org.ru
ICQ: 28073807

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Weird indices
Next
From: Denis Perchine
Date:
Subject: Re: postgres load