Trigger vs rule - Mailing list pgsql-sql

From Richard E Nairn
Subject Trigger vs rule
Date
Msg-id 20000816101655.C30950@spans.gscc.nrcan.gc.ca
Whole thread Raw
List 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 by date:

Previous
From: Martin Christensen
Date:
Subject: Many-to-one subquery
Next
From: "Francisco Hernandez"
Date:
Subject: Re: car mileage summation / sledgehammer method