In article <4989e659.3000...@computer.org>,
David Wall <d.w...@computer.org> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to