INSERT only under certain conditions (SELECT)

From: Joachim Trinkwitz <jtr(at)uni-bonn(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: INSERT only under certain conditions (SELECT)
Date: 2002-07-08 01:18:33
Message-ID: 874rfb6mqe.fsf@wabe.germanistik.uni-bonn.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I want to insert a row only under condition that there isn't already
another row with similar values -- something like a INSERT INTO
... WHERE NOT EXISTS (SELECT ...)?

Hoping for help,
joachim

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jack 2002-07-08 08:11:26
Previous Message Mirco D'Angelo 2002-07-07 21:59:51 newbie question