Re: R: [GENERAL] how to add array of objects to a record

2008-02-03 Thread David Fetter
On Sun, Feb 03, 2008 at 10:00:04PM +0100, dfx wrote: > Yes, this is the "normal" way, but I was tempted to investigate the > possibility to use array (of string) or composite types to avoid to > increase the number of tables That is an extremely bad thing to "optimize" for. Add tables as needed f

R: [GENERAL] how to add array of objects to a record

2008-02-03 Thread dfx
Yes, this is the "normal" way, but I was tempted to investigate the possibility to use array (of string) or composite types to avoid to increase the number of tables and to simplify stored procedures reducing the number of join. Thi idea was born following the discussion concerning EAV. Thank you