Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id AECF84758EF
	for <pgsql-sql@postgresql.org>; Sun,  7 Jul 2002 21:19:59 -0400 (EDT)
Mailbox-Line: From jtr@uni-bonn.de  Sun Jul  7 21:19:59 2002
Received: from f2node23.rhrz.uni-bonn.de (node23.rhrz.uni-bonn.de
	[131.220.14.223])
	by postgresql.org (Postfix) with ESMTP id 65374475469
	for <pgsql-sql@postgresql.org>; Sun,  7 Jul 2002 21:19:56 -0400 (EDT)
Received: from wabe.germanistik.uni-bonn.de (ascend-tk-p163.dialin.uni-bonn.de
	[131.220.244.163])
	by f2node23.rhrz.uni-bonn.de (AIX4.3/8.9.3/8.9.3) with ESMTP id
	DAA46304
	for <pgsql-sql@postgresql.org>; Mon, 8 Jul 2002 03:19:58 +0200
Received: by wabe.germanistik.uni-bonn.de (Postfix, from userid 1000)
	id C833FAF628; Mon,  8 Jul 2002 03:18:33 +0200 (CEST)
To: pgsql-sql@postgresql.org
Subject: INSERT only under certain conditions (SELECT)
From: Joachim Trinkwitz <jtr@uni-bonn.de>
Date: 08 Jul 2002 03:18:33 +0200
Message-ID: <874rfb6mqe.fsf@wabe.germanistik.uni-bonn.de>
Lines: 8
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Honest Recruiter)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Spam-Status: No, hits=-1.9 required=5.0
	tests=X_NOT_PRESENT
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/82
X-Sequence-Number: 8461

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