The create clause makes me confused

bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL

http://www.agensgraph.org

Other

1.34k stars 149 forks source link

The create clause makes me confused #460

Closed zzl221000 closed 5 years ago

zzl221000 commented 5 years ago

Agensgraph supports unique indexes, but when using the create clause, it seems that there is no solution to the unique index conflict. Or, how should I use ON CONFLICT? create(:node {name:'Jim',id:'12345'}),(:node {name:'Jim',id:'12345'}); I want this create clause to execute and ignore the unique index conflict

gtyun commented 5 years ago

We didn't implement ON CONFLICT clause. As far as I know there is no such syntax in the Cypher spec. If you find it, please let me know. And if what you want is ON CONFLICT DO NOTHING, you can replace it with MERGE clause.