insert iff !exist

From: "Patrick Welche" <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: insert iff !exist
Date: 1999-04-10 15:49:31
Message-ID: E10W00h-0004Ih-00@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Frisch 1999-04-10 16:26:04 Getting total records in result set
Previous Message Patrick Welche 1999-04-10 15:47:50 insert iff !exist