insert iff !exist - Mailing list pgsql-general

From Patrick Welche
Subject insert iff !exist
Date
Msg-id E10W00h-0004Ih-00@quartz.newn.cam.ac.uk
Whole thread Raw
Responses Re: [GENERAL] insert iff !exist  (Karl DeBisschop <kdebisschop@spaceheater.infoplease.com>)
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: "Patrick Welche"
Date:
Subject: insert iff !exist
Next
From: Mike Frisch
Date:
Subject: Getting total records in result set