[SQL] Question on MERGE in postgresql - Mailing list pgsql-sql

From Kaleeswaran Velu
Subject [SQL] Question on MERGE in postgresql
Date
Msg-id CABu4CrdhWMjXztD1KZPLeZODG2ZdDoAO8YWPAXhUUUCA0-POFg@mail.gmail.com
Whole thread Raw
Responses Re: [SQL] Question on MERGE in postgresql  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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.

pgsql-sql by date:

Previous
From: sqlQuestions
Date:
Subject: Re: [SQL] Conditional Lookup Table with Like
Next
From: "David G. Johnston"
Date:
Subject: Re: [SQL] Question on MERGE in postgresql