cockroachdb / cockroachdb/cockroach
sql: nested user-defined enum types
Open
A-sql-datatypes
C-enhancement
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
In Postgres:
```sql
CREATE TYPE t1 AS ENUM ('foo', 'bar');
-- CREATE TYPE
CREATE TYPE t2 AS (a t1, b t1);
-- CREATE TYPE
SELECT ('foo', 'bar')::t2;
-- row
-- -----------
-- (foo,bar)
-- (1 row)
-- SELECT pg_typeof(('foo', 'bar')::t2);
-- pg_typeof
-- -----------
-- t2
-- (1 row)
```
Jira issue: CRDB-47051
Epic CRDB-62547
Contributor guide
Assessment
This issue has not been assessed yet.