How to add new relationship in MERGE ON CREATE SET query in neo4j -

i have merge query in want merge node if exists or create new node , if new node created create new relationship linking newly created node , add properties relationship linked node

basically this:

merge ( user:user { userid : userid } )  on create set      user.password = password ,     user.userid = userid ,     (user)-[:info]->(userinfo:profileinfo {firstname:'john',lastname:'doe'}) return user 

however cant figure out how create new relationship shows error.

i need update userinfo if user inputs new info or update relationship or create new user if user not exist , create relationship well.

you can use temporary property , foreach:

merge ( user:user { userid : userid } )  on create set      user.password = password ,     user.userid = userid ,     user.iscreated = [true] foreach(ifthen in user.iscreated |     merge (user)-[:info]->(userinfo:profileinfo {firstname:'john',lastname:'doe'})     remove user.iscreated ) return user