 | |
Postgre insert without duplicate
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Postgre insert without duplicate -
03-21-2008
, 06:00 AM
|
You excuse the mine horrible English. |
Quote:
|
Example Table AAA Field1 A (key unique) Field2 B Data 1 10 2 20 3 30 Table BBB Field1 A (key unique) Field2 B Data 3 30 (Primary Key 3 already present in AAA) 4 40 5 00 I should add the data of BBB to AAA without duplications Executing: INSERT INTO AAA SELECT * FROM BBB duplication force Rollback If an any fact goes in mistake for any motive (Unique Indexes, Foreign Keys), alone the data in mistake I am to exclude. |
How about that:
INSERT INTO aaa
(SELECT * FROM bbb
WHERE NOT EXISTS (SELECT 1 FROM aaa WHERE bbb.a=aaa.a));
which would exclude all duplicates from the SELECT.
I don't think that it can be done more efficiently.
Yours,
Laurenz Albe
#22
| |||
| |||
|
|
You excuse the mine horrible English. |
Quote:
|
Example Table AAA Field1 A (key unique) Field2 B Data 1 10 2 20 3 30 Table BBB Field1 A (key unique) Field2 B Data 3 30 (Primary Key 3 already present in AAA) 4 40 5 00 I should add the data of BBB to AAA without duplications Executing: INSERT INTO AAA SELECT * FROM BBB duplication force Rollback If an any fact goes in mistake for any motive (Unique Indexes, Foreign Keys), alone the data in mistake I am to exclude. |
How about that:
INSERT INTO aaa
(SELECT * FROM bbb
WHERE NOT EXISTS (SELECT 1 FROM aaa WHERE bbb.a=aaa.a));
which would exclude all duplicates from the SELECT.
I don't think that it can be done more efficiently.
Yours,
Laurenz Albe
#23
| |||
| |||
|
|
You excuse the mine horrible English. |
Quote:
|
Example Table AAA Field1 A (key unique) Field2 B Data 1 10 2 20 3 30 Table BBB Field1 A (key unique) Field2 B Data 3 30 (Primary Key 3 already present in AAA) 4 40 5 00 I should add the data of BBB to AAA without duplications Executing: INSERT INTO AAA SELECT * FROM BBB duplication force Rollback If an any fact goes in mistake for any motive (Unique Indexes, Foreign Keys), alone the data in mistake I am to exclude. |
How about that:
INSERT INTO aaa
(SELECT * FROM bbb
WHERE NOT EXISTS (SELECT 1 FROM aaa WHERE bbb.a=aaa.a));
which would exclude all duplicates from the SELECT.
I don't think that it can be done more efficiently.
Yours,
Laurenz Albe
#24
| |||
| |||
|
|
You excuse the mine horrible English. |
Quote:
|
Example Table AAA Field1 A (key unique) Field2 B Data 1 10 2 20 3 30 Table BBB Field1 A (key unique) Field2 B Data 3 30 (Primary Key 3 already present in AAA) 4 40 5 00 I should add the data of BBB to AAA without duplications Executing: INSERT INTO AAA SELECT * FROM BBB duplication force Rollback If an any fact goes in mistake for any motive (Unique Indexes, Foreign Keys), alone the data in mistake I am to exclude. |
How about that:
INSERT INTO aaa
(SELECT * FROM bbb
WHERE NOT EXISTS (SELECT 1 FROM aaa WHERE bbb.a=aaa.a));
which would exclude all duplicates from the SELECT.
I don't think that it can be done more efficiently.
Yours,
Laurenz Albe
#25
| |||
| |||
|
|
You excuse the mine horrible English. |
Quote:
|
Example Table AAA Field1 A (key unique) Field2 B Data 1 10 2 20 3 30 Table BBB Field1 A (key unique) Field2 B Data 3 30 (Primary Key 3 already present in AAA) 4 40 5 00 I should add the data of BBB to AAA without duplications Executing: INSERT INTO AAA SELECT * FROM BBB duplication force Rollback If an any fact goes in mistake for any motive (Unique Indexes, Foreign Keys), alone the data in mistake I am to exclude. |
How about that:
INSERT INTO aaa
(SELECT * FROM bbb
WHERE NOT EXISTS (SELECT 1 FROM aaa WHERE bbb.a=aaa.a));
which would exclude all duplicates from the SELECT.
I don't think that it can be done more efficiently.
Yours,
Laurenz Albe
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.