Re: data integrity and inserts

Scott Frankel wrote:
>
> I want to ensure data integrity when inserting into a table, preventing
> multiple
> entries of identical rows of data.

Just use a unique index on the columns you want to make sure are not
duplicated.

>
> Does this call for using a trigger?
> How would triggers perform a query to test if data already exists in the
> table?
>
> (The doco outlines how triggers perform tests on NEW data inserted into a
> table; but I haven't found anything on data already extant.)
>
> Thanks in advance!
> Scott
>
>
> sample table:
>
> CREATE TABLE names (the_id SERIAL PRIMARY KEY, the_name text);
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL