Trigger or Rule?

Поиск
Список
Период
Сортировка
От Andy Lewis
Тема Trigger or Rule?
Дата
Msg-id Pine.LNX.4.05.9904260746210.25881-100000@tmg.themecca.net
обсуждение исходный текст
Ответ на re: left join  (Silvio Macedo <smacedo@inescn.pt>)
Список 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 по дате отправления:

Предыдущее
От: Silvio Macedo
Дата:
Сообщение: re: left join
Следующее
От: Adriaan Joubert
Дата:
Сообщение: Re: [GENERAL] Trigger or Rule?