softa/activerecord-postgres-hstore — Issue #14: ?| Operator does not exist
Author: arunthampi
Created: 2011-12-29 11:35:34+00:00
State: open

I'm trying to use the ?| operator on PostgreSQL 9.0.4 on Mac OS X (after running rails g hstore:setup

and I get this error:

```
ActiveRecord::StatementInvalid: PGError: ERROR: operator does not exist: hstore ?| text[]
```

This is the query that I'm trying to run:

```
Video.where("tags ?| ARRAY['lonely', 'abc']")
```

The generated SQL is

```
SELECT "videos".* FROM "videos" WHERE (tags ?| ARRAY['lonely', 'abc'])
```

TIA!