Re: My honours project - databases using dynamically attached entity-properties

"Ron Mayer" <rm_pg@cheapcomplexdevices.com> writes:

> I have a system with many essentially user-defined fields, and was
> thinking of creating something similar to an Array type and writing
> some GIST indexes for it.
>
> My current workaround is to store them as a YAML document and use
> tsearch to index it (with application logic to further refine the
> results) - but a EAV datatype that could be put in tables and
> effectively indexed would be of quite a bit of interest here.
> And yes, a better say to do UDFs would be even cooler.

I think that's what hstore does. Honestly I'm not entirely certain though.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com