Re: domains, types, constraints - Mailing list pgsql-novice

Andrew Winkler <the_andrew_winkler@yahoo.com> writes:
> postgres=# create type complex as (r numeric, i numeric);
> CREATE TYPE
> postgres=# create domain unitary as complex;
> ERROR:  "complex" is not a valid base type for a domain

> Are composite types not useable for domains?

Nope, sorry.  We currently only support domains over base types.

I don't think anyone's even thought about doing the above, though
it does seem like a potentially useful thing.

            regards, tom lane