Filtering duplicated row with a trigger
От | papapep |
---|---|
Тема | Filtering duplicated row with a trigger |
Дата | |
Msg-id | 3F8198A5.9040905@gmx.net обсуждение исходный текст |
Ответы |
Re: Filtering duplicated row with a trigger
Re: Filtering duplicated row with a trigger |
Список | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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? Thanks. Josep Sànchez [papapep] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/gZik2vx52x0kyz4RApbZAKCrhvCywbNH8Zce0xpfDhMNQBfQ+ACfShG6 96nY7di8KnV8gJrcWIOzqLI= =32il -----END PGP SIGNATURE-----
В списке pgsql-novice по дате отправления: