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
