Here is a sample table: item item_id int name char attrib1 char attrib2 char attrib3 char
One problem with the above is that the list of attributes is fixed. I am looking for a way to assign new, previously undefined, attributes to items without changing the table structure. Is it ever appropriate to do the following? item item_id int name char details item_id int attribute_name char attribute_value char If this is a reasonable technique are their guidelines for its use? When is it approptiate? When not? Thanks, Bob ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster