Received: from spans.gscc.nrcan.gc.ca (IDENT:root@spans.gscc.nrcan.gc.ca [132.156.107.22]) by hub.org (8.10.1/8.10.1) with ESMTP id e7GGH4n77779 for ; Wed, 16 Aug 2000 12:17:04 -0400 (EDT) Received: (from ren@localhost) by spans.gscc.nrcan.gc.ca (8.9.3/8.9.3) id KAA08206 for pgsql-sql@hub.org; Wed, 16 Aug 2000 10:16:55 -0600 Date: Wed, 16 Aug 2000 10:16:55 -0600 From: Richard E Nairn To: pgsql-sql@hub.org Subject: Trigger vs rule Message-ID: <20000816101655.C30950@spans.gscc.nrcan.gc.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Archive-Number: 200008/147 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 **