Clojurians Log v2

hi people

i'm having a problem using hugsql and i wondered if anyone here could help

i have a table like create table foo(bar varchar[]) with an array-of-varchar column

i'm trying to select from this like select * from foo where :param = any(bar)

but this throws org.postgresql.util.PSQLException: No hstore extension installed.

however, from psql i can query like that without problem select * from foo where "baz" = any(bar)

any idea how could i get this working?

or in case arrays of varchar is a Very Bad Thing to use, could you suggest an alternative? this is my first time using pgsql

apparently the java abstractions for pgsql data structures need hstore installed

so i did that and now it works!