From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: hstore improvements? |
Date: | 2009-03-16 16:38:25 |
Message-ID: | 49BE8081.1070708@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Ron,
> I imagine most EAV systems allow multiple values for each
> attribute - and a hstore that supported this could probably
> be a pretty nice general solution for many EAV systems. IIRC
> other people asked about similar on the lists before.
Well, not usually. Generally, since EAV systems are
entity-attribute-value, the key for the table is generally
entity-attribute. I've seen a few which were
entity-attribute-attributenumber-value, but those are rare.
Overally, I think the ability to stick an array into an hstore value
would take care of most real uses. Beyond that, we're encouraging
people to use hstore in ways it won't actually scale.
--Josh
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Olszak | 2009-03-16 16:50:16 | Re: Problem with accesing Oracle from plperlu functionwhen using remote pg client. |
Previous Message | Magnus Hagander | 2009-03-16 16:37:42 | Re: Problem with accesing Oracle from plperlu functionwhen using remote pg client. |