merge1.sql

application/sql

Filename: merge1.sql
Type: application/sql
Part: 0
Message: Re: support for MERGE
MERGE INTO public.idxpart3 as target_0
USING public.rtest_view2 as ref_0
ON target_0.a = ref_0.a 
WHEN NOT MATCHED AND (pg_catalog.lastval() = cast(null as int2)) or (true) 
   THEN INSERT VALUES ( 20);