Hi,
I've recently been trying to make use of domains but have
encountered some violations of the rule of least surprise.
(PostgreSQL 7.4.2)
I couldn't create an array of a domain, eg:
CREATE DOMAIN mydomain AS integer;
CREATE TABLE mytable (
stuff mydomain[]
);
results in:
Is there any reason why a domain cannot use another domain as it's base
type?
It hasn't been written yet, but Tom has spent some time ensuring the
system could be expanded to deal with this.
And why isn't an array type created for a domain?
(Is there a way to create an array for a domain