"Ron Mayer" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly