Re: [personal] Re: Filtering duplicated row with a trigger - Mailing list pgsql-novice

From papapep
Subject Re: [personal] Re: Filtering duplicated row with a trigger
Date
Msg-id 3F81A63D.1080007@gmx.net
Whole thread Raw
In response to Re: [personal] Re: Filtering duplicated row with a trigger  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [personal] Re: Filtering duplicated row with a trigger
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Josh Berkus wrote:
| Josep,
|
| Are you a Spanish speaker?  Or Brazillian?   I'd like to get someone
to help
| you, or at least translate, in a language you are more comfortable
with.  So
| far, nobody on this list is clear on what you want help doing.
|

I'm very sorry for not being able to explain my problem (BTW, I'm
spanish speaker...)
I'll try to do it better.

I've got a table that has the following fields:

    F1 F2 F3 F4 F5 .........F16

and we have defined that there can't be any field repeating the fiels
F1,F2,F5,F14 and F15 (our, complex, primary key).

I've got, on the other hand, text files prepared to be inserted in this
table with the \copy command, but we are not sure (we've found
duplicated rows several times) that there are not repeated rows.

I'm trying to create a function that controls these duplicated rows to
keep the table "clean" of them. In fact, I don't mind if the duplicated
rows are inserted in a "duplicated rows" table (but perhaps it should be
a good way to detect where they are generated) or if they get "missed in
action".

I hope (I really, really do...) that this time I've been able to explain
it better.

Thanks to all for your patience.

Josep Sanchez
[papapep]

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/gaY82vx52x0kyz4RAhXrAKDGD1NRuUt2nufdtt74wuDwg4zEQgCgmRc/
/x1V5EtYriZ6Pw+zm3n6kro=
=GILj
-----END PGP SIGNATURE-----




pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: [personal] Re: Filtering duplicated row with a trigger
Next
From: Bruno Wolff III
Date:
Subject: Re: [personal] Re: Filtering duplicated row with a trigger