am Thu, dem 05.04.2007, um 10:38:21 +0200 mailte Shavonne Marietta Wijesinghe folgendes: > Hello everyone.. > > Here is the result of my Insert. and also the insert works ok. > > INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC, > TE_LUONASC, TE_DTNASC, TE_PROVSTATO, TE_PROV, TE_PATERNITA, TE_RICHIESTA, > USERNAME, DATE_INSERTED, TIME_INSERTED) VALUES ('127001200745101033', > 'england', 'bloom', 'orlando', 'M', 'ww', 'florida', '05/06/1984', 'america', > 'UK', 'xx', 'no', 'demo', '05/04/2007', '10.10.33'); > But before i insert this record i want to check if the it hasn't been inserted > before. I want to use the following fields as the riefferent. TE_COGNOME, > TE_NOME, TE_SESSO, TE_DTNASC > > And if there is no record to match those 4 fields i want to insert it else > just > a message saying that the record has been inserted b4. > > any idea to start with?
Yes, read this: http://ads.wars-nicht.de/blog/archives/11-Avoid-Unique-Key-violation.html I think, you can change this for your request. (but without the message, if you really need this message, you should use a function and RAISE a NOTICE as the message) Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly