-----BEGIN PGP SIGNED MESSAGE-----
I've got plenty of data files (prepared to be inserted with the \copy
statement) but I have to filter them to be sure that there are no
duplicated rows inserted.
I know I should do it with a trigger that executes a function before
inserting the row and if it's duplicated do something with it (insert it
in another table, simply forget it, etc...). The theory is clear :-)
But the practice is not so clear (for me, of course).
Anyone can give me some guide to how the function should do the control
of duplicated rows?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
pgsql-novice by date
|Next:||From: Nabil Sayegh||Date: 2003-10-06 16:43:31|
|Subject: Re: Filtering duplicated row with a trigger|
|Previous:||From: Menke, Kurt||Date: 2003-10-06 14:49:26|
|Subject: Re: importing data automatically|