Re: hstore improvements?

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

In response to

Browse pgsql-hackers by date

  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.