Re: How to release SET() in PgSQL?

Andrey Y. Mosienko writes:

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

You could split that off into a separate table, e.g.,

CREATE TABLE test1 (
id int,
/* the rest of the columns in your "test" */
);

CREATE TABLE test2 (
id int references test1,
a varchar check a in ('one', 'two', 'three')
);

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/