#363 Add ENUM support in postgres compatibility mode

[Pavel Moukhataev]

Can you add ENUM support in postgres compatibility mode:

for example to make this work

CREATE TYPE my_group_type AS ENUM ('DEPARTMENT', 'SERVICE', 'SERVICEROLE', 'WIKI');

CREATE TABLE my_group (
  id                    bigserial PRIMARY KEY,
  url_acceptable_key    short_text NOT NULL UNIQUE,
  group_type  my_group_type NOT NULL
);

UPDATE my_group SET url_acceptable_key = :url, group_type = CAST
(:groupType as my_group_type) WHERE id = :groupId;

[Fred Toussi]

In HSQLDB you can use SQL Standard syntax to create a DOMAIN instead:

CREATE DOMAIN my_group_type AS VARCHAR(20) CHECK (VALUE IN ('DEPARTMENT', 'SERVICE', 'SERVICEROLE', 'WIKI'))