How to release SET() in PgSQL?

From: "Andrey Y(dot) Mosienko" <feo(at)ttn(dot)ru>
To: Postgres <pgsql-general(at)postgresql(dot)org>
Subject: How to release SET() in PgSQL?
Date: 2001-02-21 08:48:47
Message-ID: 3A9380EF.838126EE@ttn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ttn(dot)ru, feo(at)feo(dot)org(dot)ru
ICQ: 28073807

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pete Forman 2001-02-21 08:53:58 Re: vacuum analyze again...
Previous Message Denis Perchine 2001-02-21 08:47:51 Re: postgres load