Re: [personal] Re: Filtering duplicated row with a trigger

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: Raw Message | Whole Thread | 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-----

In response to

Browse pgsql-novice by date

  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