Le jeudi 16 décembre 2010 à 15:18 -0500, Bryan Montgomery a écrit : > Thanks for the comments. Just to clarify, I gave these two values as > examples. The readings could be between a handful for one vehicle type > up to 40 or more for another type of vehicle. > Not sure what you call a reading? do you mean like a parameter? if so give it its own column with an appropriate type. Your table would then have 40 columns, some of them being empty for some type of vehicle. If a reading really is a record, then you want a subclass, with a foreign key referencing the primary key of your vehicle table. You can then have un unlimited number of records (again, each record having a column for each of the parameters/characteristics measured) . -- Vincent Veyron http://marica.fr/ Progiciel de gestion des dossiers de contentieux et d'assurance pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
