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

-----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-----