In article <4989E659.3000706@xxxxxxxxxxxx>, David Wall <d.wall@xxxxxxxxxxxx> writes: > If I have an "unlimited" number of name-value pairs that I'd like to > get easy access to for flexible reports, could I store these in two > arrays (one for name, the other for value) in a table so that if I had > 10 name-value pairs or 200 name-value pairs, I could store these into > a single row using arrays so I could retrieve all name-value pairs in > a single SELECT from the db? I would use the hstore contrib module for that. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
