[DBIx-Class-Devel] [sql-abstract] Custom methods for HSTORE and ANY ( method ) in psql (#2)

[Dagfinn Ilmari Mannsåker]

@ribasushi: The generic operator support is not quite enough for `ANY`, since the syntax is `foo = ANY(?)` (see http://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN19686):
````
$ reply
0> my $s = SQL::Abstract->new
[…]
1> $s->where({foo => { -any => { -value => [2] } }})
$res[1] = [
  ' WHERE ( foo ANY ? )',
  [
    2
  ]
]

5> $s->where({foo => { '=' => { -any => { -value => [2] }}}})
$res[2] = [
  ' WHERE ( foo = (ANY ?) )',
  [
    2
  ]
]
```

---
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-abstract/pull/2#issuecomment-70488592
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20150119/311e4eed/attachment.htm>