Support Postgres' HSTORE

[paulolieuthier]

No description provided.

[jhaber]

Hey thanks for the issue! I haven't used HSTORE before, could you provide more detail about what you're looking for? Would you expect this to work for both binding and mapping? How would you expect the calling Java code to look?

[paulolieuthier]

Hey, there.

Hstore is a very useful way to store a key-value structure in Postgres. Jdbi supports it and integration is very smooth for Map<String, String>. However, I'd like to use an enum as value (Map<String, MyEnum>).

With Rosetta I can get the hstore to be mapped to the map, but with a problem: an extra key is always added, I couldn't find out why. The key is the name of the column, and value is always null.

I've built a simple application showing the issue: rosetta-test-case.zip.

Thanks for you time, nice project by the way!

[paulolieuthier]

@jhaber any progress on that? Thanks.