-----Original Message-----
From: [email protected] 
[mailto:[email protected]] On Behalf Of erhaminus
Sent: Wednesday, October 19, 2011 10:33 AM
To: [email protected]
Subject: [GENERAL] Composite type, DEFAULT, NOT NULL, REFERENCES


Hi,

Is a way to define DEFAULT, NOT NULL and REFERENCES for members of composite 
type?

--------------------/Original Message---------------

The only way to constrain a Type is to use a DOMAIN but whether you can domain 
a composite type I do not know.

There is no concept of "Foreign Key" when it comes to Types, only Tables.

David J.



-- 
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to