Insert only if not found

From: "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Insert only if not found
Date: 2007-04-05 08:38:21
Message-ID: 005b01c7775d$c4fa4b70$1102a8c0@dream
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Shavonne Wijesinghe

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-04-05 08:53:43 Re: Insert only if not found
Previous Message Tom Lane 2007-04-05 05:47:03 Re: slow query