Re: Ignore unique violations?

On Thu, Mar 27, 2008 at 2:52 AM, A. Kretschmer
<andreas(dot)kretschmer(at)schollglas(dot)com> wrote:

> am Thu, dem 27.03.2008, um 9:45:33 +0000 mailte A B folgendes:
>
> > Is there any easy way of ignoring unique violations?
> > I have a table (a integer, b integer, unique (a,b) ) and want to
> > insert pairs of values for a and b, but I do not want to first select
> > to see if there is a pair before inserting.
> > So can I make postgres ignore any error or exception?
>
> I hope this link can help you:
> http://andreas.scherbaum.la/blog/archives/11-Avoid-Unique-Key-violation.html
>
>

Here is different syntax for the same solution.

INSERT INTO Table ( a, b )
SELECT T1.a, T1.b
FROM ( VALUES( 1, 2 )) AS T1( a, b )
LEFT OUTER JOIN Table AS T2
ON ( T1.a, T1.b ) = ( T2.a, T2.b )
WHERE ( T2.a, T2.b ) IN NULL;

--
Regards,
Richard Broersma Jr.