Need to execute 'update .... ' statement, when data found while 'inserting data...', from datawindow
PB 2017, Postgresql 10.
Giving facility to import records from XML and Excel. While importing records, few records might already available in database and need to be either excluded or updated. This query is available in Postgres.
Can we use this
INSERT ... ON CONFLICT DO NOTHING/UPDATE
Support for UPSERT functionality which allows either no action to be taken when a conflict is encountered, or convert the INSERT to an UPDATE.
facility from datawindow ?