Trigger or Rule? - Mailing list pgsql-general

From Andy Lewis
Subject Trigger or Rule?
Date
Msg-id Pine.LNX.4.05.9904260746210.25881-100000@tmg.themecca.net
Whole thread Raw
In response to re: left join  (Silvio Macedo <smacedo@inescn.pt>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Silvio Macedo
Date:
Subject: re: left join
Next
From: Adriaan Joubert
Date:
Subject: Re: [GENERAL] Trigger or Rule?