MERGE INTO not working with Postgres 9.6
<p>In my Postgres 9.6 environment, when I try to execute "MERGE INTO" query, it throws me following error:</p>

<pre><code>ERROR:  syntax error at or near "MERGE"
LINE 1: MERGE INTO Stock USING Buy ON Stock.item_id = Buy.item_id  W...
        ^
</code></pre>

<p>It seems like it does not support MERGE query. However when I do google, it seems that MERGE is supported by Postgres since version 9.1.</p>

<p>Please tell me whats going wrong here.</p>

<p>Edit: Following are the sources from where I found MERGE support in Postgres.</p>

<p><a href="https://wiki.postgresql.org/wiki/MergeTestExamples" rel="nofollow noreferrer">https://wiki.postgresql.org/wiki/MergeTestExamples</a></p>