Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group