On 12/08/2014 15:57, Jimmy Thrasibule wrote: >> Is there a reason why hstore or json is not an option? That may work a lot >> better than this approach. > > I don't want to move away from SQL common features so I can have a > test environment using SQLite and deploy on PostgreSQL. This approach > looks elegant and simple to me. Using a new table per attribute type > or even per attribute for the values, I can easily index them for > quick lookups.
What is your test environment? Postgres works quite happily on my rather low-powered Windows 7 laptop, and so I have all the bells and whistles available for development. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general