domain over enum problem

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: domain over enum problem
Date: 2011-01-11 17:37:02
Message-ID: 1294767422.17361.3.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-01-11 18:05:04 Re: domain over enum problem
Previous Message Kevin Grittner 2011-01-11 17:12:15 Re: BUG #5830: Cannot connect to the server