Re: most idiomatic way to "update or insert"?

I use stored procedures :

create function insertorupdate(....)
    UPDATE mytable WHERE ... SET ...
    IF NOT FOUND THEN
        INSERT INTO mytable ...
    END IF;


    You lose flecibility in your request though.

    I wish Postgresql had an INSERT OR UPDATE like MySQL does. So far it's
the only thing that I regret from MySQL.