| 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: | Whole Thread | Raw Message | 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? |