activerecord-postgres-hstore icon indicating copy to clipboard operation
activerecord-postgres-hstore copied to clipboard

Does this plugin support a null value in hstore column?

Open tamoyal opened this issue 12 years ago • 1 comments

I got a syntax error, assuming that AR didn't know how to serialize the hash into an hstore query part and saw a few posts saying I needed to add this: serialize :offer_providers, ActiveRecord::Coders::Hstore which I initially avoided because I want to select on rows with my hstore column null.

As I suspected, this does set the hstore to empty as opposed to null. How can I get the serialization but not have it save {} when I don't have any values for the hstore?

tamoyal avatar Jul 14 '13 05:07 tamoyal

Sorry it's late. The value is actually null in the database but comes out as {} when accessing it. It's a little weird but no strong opinions

tamoyal avatar Jul 14 '13 05:07 tamoyal