X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AD40FD836F; Wed, 12 Oct 2005 23:52:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78963-09; Thu, 13 Oct 2005 02:52:00 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4EC15D836D; Wed, 12 Oct 2005 23:52:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j9D2q48L016843; Wed, 12 Oct 2005 22:52:04 -0400 (EDT) To: Jeff Williams Cc: pgsql-sql@postgresql.org, pgsql-docs@postgresql.org Subject: Re: [SQL] Update timestamp on update In-reply-to: <434DC97E.7000603@globaldial.com> References: <434DB482.1000205@globaldial.com> <16305.1129167889@sss.pgh.pa.us> <434DC97E.7000603@globaldial.com> Comments: In-reply-to Jeff Williams message dated "Thu, 13 Oct 2005 10:42:06 +0800" Date: Wed, 12 Oct 2005 22:52:04 -0400 Message-ID: <16842.1129171924@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/32 X-Sequence-Number: 3277 Jeff Williams writes: > Thanks. Triggers was my first thought, but chapter 35 on Triggers didn't > really indicate a way I could do this easily and scared me with a lot of > c code. Yeah. This is a documentation issue that's bothered me for awhile. The problem is that we treat the PL languages as add-ons and therefore the documentation of the "core" system shouldn't rely on them ... but that leaves us presenting C-code triggers as the only examples in chapter 35. There is a paragraph in there suggesting you go look at the PL languages first, but obviously it's not getting the job done. Anybody have a better idea? regards, tom lane