Re: [GENERAL] Trigger or Rule?

Why wouldn't you just use a unique index or perhaps the primary key?

-----Original Message-----
From: Andy Lewis <alewis(at)themecca(dot)net>
To: pgsql general mailing list <pgsql-general(at)postgreSQL(dot)org>
Date: Monday, April 26, 1999 7:52 AM
Subject: [GENERAL] Trigger or Rule?

>I have a table that among other things has a name, address, city, state
>fields. When I insert into, I want to be able to make sure that there is
>no duplicate records or that a row is inserted that is already in the DB.
>
>Question number one is: Should I use a trigger or a rule?
>
>And request number two is perhaps a sample that could get me started.
>
>I've read thru the Documentation and Man pages and tried creating a rule
>but, had no luck.
>
>Thanks in advance.
>
>Andy
>
>
>