| From: | papapep <papapep(at)gmx(dot)net> |
|---|---|
| To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: [personal] Re: Filtering duplicated row with a trigger |
| Date: | 2003-10-06 17:39:16 |
| Message-ID: | 3F81A8C4.7020008@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Bruno Wolff III wrote:
| And what do want to happen when you run accross a duplicate row?
| Do you just want to discard tuples with a duplicate primary key?
Initially I wanted to do so. But after I thought to "register" them in a
dups table.
| If you are discarding duplicates, do you care which of the duplicates
| is discarded?
That's why I said that perhaps it should be a good thing to keep them in
a duplicated-rows table, for reviewing them.
| If you want to combine data from the duplicates, do you have a precise
| description of what you want to happen?
No, I do not need to combine data from the duplicated. The entire row is
accepted or not.
Josep Sànchez
[papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/gajE2vx52x0kyz4RAq17AJ9DNYKwJEvTHy/rc9I1hJ8AuIvDjACdEXde
4nvgabqLCdERKWIAo4v6WUI=
=7zFZ
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-10-06 17:40:32 | Re: [personal] Re: Filtering duplicated row with a trigger |
| Previous Message | Bruno Wolff III | 2003-10-06 17:33:37 | Re: [personal] Re: Filtering duplicated row with a trigger |