Обсуждение: Trigger vs rule

Поиск
Список
Период
Сортировка

Trigger vs rule

От
Richard E Nairn
Дата:
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    **