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

Поиск
Список
Период
Сортировка
От papapep
Тема Re: [personal] Re: Filtering duplicated row with a trigger
Дата
Msg-id 3F81A8C4.7020008@gmx.net
обсуждение исходный текст
Ответ на Re: [personal] Re: Filtering duplicated row with a trigger  (Bruno Wolff III <bruno@wolff.to>)
Список 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-----




В списке pgsql-novice по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: [personal] Re: Filtering duplicated row with a trigger
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [personal] Re: Filtering duplicated row with a trigger