Hello,
I'm new to Pg and exploring its advanced functionalities for a project.
I find composite type very interesting, but what are problems/limitations ?
I'd want to create this structure for example:
Phone
Nom du champ
Type
Accès
Clef
Commentaire
typ_tel
integer
type téléphone (liste 25)
tel_pre
varchar(5)
Préfixe international téléphone
tel_num
varchar(14)
tel_ext
varchar(5)
Numéro de poste
and other structures for address and timestamp fields (creation and update timestamps.
Is it a good idea ? Are index, constraints possible/easy on subfields ?
Thank you