<p><a href="https://github.com/ribasushi" class="user-mention">@ribasushi</a>: The generic operator support is not quite enough for <code>ANY</code>, since the syntax is <code>foo = ANY(?)</code> (see <a href="http://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN19686">http://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN19686</a>):</p>
<pre><code>$ 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
]
]
</code></pre>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-abstract/pull/2#issuecomment-70488592">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAqhT3RG1ebJy2LKuKeEvU_dqep4Kks5njPbDgaJpZM4BwK_I.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/dbsrgits/sql-abstract/pull/2#issuecomment-70488592"></link>
<meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>