Andrew Winkler <the_andrew_winkler(at)yahoo(dot)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
In response to
pgsql-novice by date
|Next:||From: Jason Tan Boon Teck||Date: 2008-01-18 02:33:43|
|Subject: Duplicate primary keys|
|Previous:||From: Andrew Winkler||Date: 2008-01-17 16:23:41|
|Subject: Re: domains, types, constraints|