Trigger vs rule

Поиск
Список
Период
Сортировка
От Richard E Nairn
Тема Trigger vs rule
Дата
Msg-id 20000816101655.C30950@spans.gscc.nrcan.gc.ca
обсуждение исходный текст
Список pgsql-sql
I am in the process of creating a database to keep of my car's fuel costs
and mileage. I am having a little bit of trouble deciding if I need to use
a rule to do what I want or a trigger. I have created a SQL function that
will update the mileage field, but when I try and create a trigger for it,
it says it needs to return OPAQUE, but if i recreate my SQL function it
won't accept OPAQUE as a return type. 

Any Ideas?

-- 
Richard Nairn
Nairn Consulting
** Email ren@spans.gscc.nrcan.gc.ca   **
**     nairnr@cadvision.com         **
**       nconsulting@cadvision.com    **


В списке pgsql-sql по дате отправления:

Предыдущее
От: Martin Christensen
Дата:
Сообщение: Many-to-one subquery
Следующее
От: "Francisco Hernandez"
Дата:
Сообщение: Re: car mileage summation / sledgehammer method