Date: Thu, 13 Oct 2005 10:22:53 -0400
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Update timestamp on update
Message-ID: <20051013142253.GB16317@phlogiston.dyndns.org>
References: <434DB482.1000205@globaldial.com> <16305.1129167889@sss.pgh.pa.us>
	<434DC97E.7000603@globaldial.com> <16842.1129171924@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <16842.1129171924@sss.pgh.pa.us>
User-Agent: Mutt/1.5.9i

On Wed, Oct 12, 2005 at 10:52:04PM -0400, Tom Lane wrote:
> 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?

It could just be made a little friendlier, I think.  At the beginning
of the trigger chapter is this:

--snip--
This chapter describes how to write trigger functions. Trigger
functions can be written in C or in some of the available procedural
languages. It is not currently possible to write a SQL-language
trigger function.
--snip--

We could just add a little note by way of modification.  Here's a
(somewhat verbose, I fear) suggestion:

--snip--
This chapter describes how to write trigger functions. Trigger
functions can be written in C or in some of the available procedural
languages. This chapter deals only with functions that are written in
C. If you are unfamiliar with C, you may want also to look at the
chapters on procedural languages, because there are some examples
there that may be easier for you to understand.  To use a procedural
language for a trigger, you will need to install that language; see
the relevant chapter for instructions on how to do so.  It is not
currently possible to write a SQL-language trigger function.
--snip--

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
		--Roger Brinner