domain over enum problem - Mailing list pgsql-bugs

From Peter Eisentraut
Subject domain over enum problem
Date
Msg-id 1294767422.17361.3.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: domain over enum problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
CREATE TYPE zzz_enum AS ENUM ('A', 'B', 'C');
CREATE TABLE zzz_test1 (z zzz_enum);
SELECT * FROM zzz_test1 WHERE z = 'A';

That works.  But:

CREATE DOMAIN zzz AS zzz_enum DEFAULT 'A';
CREATE TABLE zzz_test2 (z zzz);
SELECT * FROM zzz_test2 WHERE z = 'A';
ERROR:  42883: operator does not exist: zzz = unknown

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5830: Cannot connect to the server
Next
From: Tom Lane
Date:
Subject: Re: domain over enum problem