We return just what psycopg2 gives us, and I'm not able to reproduce "empty HSTORE as None" - you get NULL as None, empty as {}.
Test case: from sqlalchemy import Table, MetaData, create_engine # work around ticket 2680 (reflection, but doesn't matter here) from sqlalchemy.dialects.postgresql import HSTORE, base base.ischema_names['hstore'] = HSTORE engine = create_engine("postgresql://scott:tiger@localhost/test") connection = engine.connect() # do raw psycopg2 conn = connection.connection cursor = conn.cursor() cursor.execute("create table test (name varchar(10), data hstore)") cursor.execute("INSERT INTO test (name, data) VALUES(%s, %s)", ('blank', {},)) cursor.execute("INSERT INTO test (name, data) VALUES(%s, %s)", ('null', None,)) cursor.execute("select name, data from test") # raw psycopg2 output print cursor.fetchall() # do SQLAlchemy t = Table('test', MetaData(), autoload=True, autoload_with=connection) # SQLAlchemy output print connection.execute(t.select()).fetchall() output: [(u'blank', {}), (u'null', None)] [(u'blank', {}), (u'null', None)] On Mar 11, 2013, at 7:07 PM, Charles-Axel Dein <c...@d3in.org> wrote: > Hi, > > Currently, when getting an empty HSTORE column from a model instance, it is > returned as None. Do you think it would be more logical to have it returned > as an empty dict? > > Thanks, > > Charles > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.