From: | Richard E Nairn <ren(at)spans(dot)gscc(dot)nrcan(dot)gc(dot)ca> |
---|---|
To: | pgsql-sql(at)hub(dot)org |
Subject: | Trigger vs rule |
Date: | 2000-08-16 16:16:55 |
Message-ID: | 20000816101655.C30950@spans.gscc.nrcan.gc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)spans(dot)gscc(dot)nrcan(dot)gc(dot)ca **
** nairnr(at)cadvision(dot)com **
** nconsulting(at)cadvision(dot)com **
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-08-16 16:25:42 | Re: Is this the wrong list? |
Previous Message | Chris Ryan | 2000-08-16 13:54:40 | Re: Is this the wrong list? |