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:47:50
Message-ID: E10Vzz5-0004IR-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

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Welche 1999-04-10 15:49:31 insert iff !exist
Previous Message AGRE Enterprises Limited 1999-04-10 05:18:48 Problem with 6.5 reload