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

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@gmx.net       http://yi.org/peter-e/