Thank you for the answer Grzegorz.
> if you have a primary key on the table, and you should, you might get better
> performance using LEFT JOIN.
Well as far as I know, the result of such JOIN is a cartezian product, which is
not exactly what I need. I need the same structure as table 'data' has
if you have a primary key on the table, and you should, you might get better
performance using LEFT JOIN.
EXCEPT will compare all columns, which might not be that fast, especially if
those are text. (hence why I always tell others to use int as key in a
table, but that's a different story).
--
G
Hello,
everyday I collect a couple of thousands rows of unique data from our
systems and I INSERT them into the table. Since I need no duplicate
data, I use EXCEPT clause when INSERTing, like this:
===
INSERT INTO data SELECT * FROM new_collected_data() EXCEPT SELECT * FROM
data;
===
It works e
