From: Marc G. Fournier <scrappy@postgresql.org>
To: pgsql-sql@postgresql.org
Subject: Skip dups on INSERT instead of generating an error ...
Date: Fri, 12 Dec 2003 16:53:55 -0400 (AST)
Message-ID: <20031212165007.L81928@ganymede.hub.org> (raw)
I need to be able to run an INSERT INTO / SELECT FROM UNION which combines
two tables into one ... *but* ... the INTO table has a primary key on the
first column, so if the result of the UNION generates dups, by default, of
course, it will generate errors ... what I'd like is to have it so that it
just skips over those records.
First thought would be to write a quite plpgsql function that would do a
SELECT first, to see if the value already exists, and if not, then do the
INSERT ... but am wondering if maybe there is a cleaner way that I'm not
thinking of?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scrappy@postgresql.org
Subject: Re: Skip dups on INSERT instead of generating an error ...
In-Reply-To: <20031212165007.L81928@ganymede.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox