Question on MERGE in postgresql

From: Kaleeswaran Velu <kaleeswaran(dot)velu(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question on MERGE in postgresql
Date: 2017-02-18 15:32:20
Message-ID: CABu4CrdhWMjXztD1KZPLeZODG2ZdDoAO8YWPAXhUUUCA0-POFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greeting all,
I am using postgresql 9.4. When I try to use "Merge" command, seems not
working.

Below is the SQL statement I used. Even after I removed the business logic
part for debugging purpose, it dose not work.

MERGE INTO util.comment C
USING util.comment_orig B
ON C.jl_id_per_book = B.jl_id_per_book
WHEN MATCHED DO NOTHING;

ERROR: syntax error at or near "MERGE"
LINE 2: MERGE INTO util.comment C
^
********** Error **********

ERROR: syntax error at or near "MERGE"
SQL state: 42601
Character: 8

Any help is appreciated!

Thanks and Regards
Kalees.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2017-02-18 15:39:53 Re: Question on MERGE in postgresql
Previous Message sqlQuestions 2017-02-17 17:58:57 Re: Conditional Lookup Table with Like