<p>You cannot add an index on an expression (aka a functional index) using a function that more than one argument like shown in the following test addition:</p>
<p>git diff t/47postgres-producer.t<br>
diff --git a/t/47postgres-producer.t b/t/47postgres-producer.t<br>
index 9c50db7..c2db844 100644<br>
--- a/t/47postgres-producer.t<br>
+++ b/t/47postgres-producer.t<br>
@@ -686,6 +686,14 @@ is($view2_sql1, $view2_sql_replace, 'correct "CREATE OR REPLACE VIEW" SQL 2');<br>
($def) = SQL::Translator::Producer::PostgreSQL::create_index($index, $quote);<br>
is($def, 'CREATE INDEX "myindex" on "foobar" USING hash ("bar", lower(foo)) WHERE upper(foo) = 'bar' AND bar = 'foo'', 'index using &amp; where created w/ quotes');<br>
}<br>
+</p>
<ul>
<li>{</li>
<li>
<pre><code>   my $index = $table-&gt;add_index(name =&gt; 'myindex', fields =&gt; ['coalesce(foo, 0)']);
</code></pre>
</li>
<li>
<pre><code>   my ($def) = SQL::Translator::Producer::PostgreSQL::create_index($index);
</code></pre>
</li>
<li>
<pre><code>   is($def, "CREATE INDEX myindex on foobar (coalesce(foo, 0))", 'index created');
</code></pre>
</li>
<li>
<pre><code>   ($def) = SQL::Translator::Producer::PostgreSQL::create_index($index, $quote);
</code></pre>
</li>
<li>
<pre><code>   is($def, 'CREATE INDEX "myindex" on "foobar" (coalesce(foo, 0))', 'index created w/ quotes');
</code></pre>
</li>
<li>}<br>
}</li>
</ul>
<p>my $drop_view_opts1 = { add_drop_view =&gt; 1, no_comments =&gt; 1, postgres_version =&gt; 8.001 };</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/83">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAnEgrDgjXA-vesEcaf52yfbYjA_8ks5rGImzgaJpZM4LIYEz">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAgmi812JBb34DzqC_F238YfiCS6Kks5rGImzgaJpZM4LIYEz.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-translator/issues/83"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"PostgreSQL parser does not allow indexes on expressions with more than one argument (#83)"}],"action":{"name":"View Issue","url":"https://github.com/dbsrgits/sql-translator/issues/83"}}}</script>