on duplicate update equivalent?

[Vijay Ramachandran]

Hello.

Is there a way to write a query with a behaviour equivalent to mysql's "on
duplicate update"? i.e., try to insert, and if key exists, update the row
instead?

thanks,