insert iff !exist - Mailing list pgsql-general

From Patrick Welche
Subject insert iff !exist
Date
Msg-id E10Vzz5-0004IR-00@quartz.newn.cam.ac.uk
Whole thread Raw
List pgsql-general
I'm pretty sure someone already answered this, but the mail archive isn't
very searchable at the moment. How can you

if(update row fails because doesn't exist, ie. returns 0)then(insert row)

in SQL? Or am I misremembering and it was in some other language?

Cheers,

Patrick

pgsql-general by date:

Previous
From: AGRE Enterprises Limited
Date:
Subject: Problem with 6.5 reload
Next
From: "Patrick Welche"
Date:
Subject: insert iff !exist