Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id F20BA476744
	for <pgsql-sql@postgresql.org>; Fri, 10 Jan 2003 17:27:26 -0500 (EST)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by postgresql.org (Postfix) with ESMTP id B3E54476B85
	for <pgsql-sql@postgresql.org>; Fri, 10 Jan 2003 17:26:43 -0500 (EST)
Received: from [216.135.165.74] (account <josh@agliodbs.com>)
	by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2)
	with HTTP id 2310311; Fri, 10 Jan 2003 14:26:49 -0800
From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: function does not exist
To: "Dave A." <pgadmin@pod13.com>, <pgsql-sql@postgresql.org>
X-Mailer: CommuniGate Pro Web Mailer v.4.0.2
Date: Fri, 10 Jan 2003 14:26:49 -0800
Message-ID: <web-2310311@davinci.ethosmedia.com>
In-Reply-To: <001c01c2b8f6$ce15dc80$fd00000a@pod13.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/159
X-Sequence-Number: 11024

Dave,

A trigger function does not take variable parameters, gets its data
from the NEW or OLD records, and returns OPAQUE with the RETURN NEW
statement.

Please check out the documentation on writing PL/pgSQL triggers under
Procedural Languages in the online docs.

-Josh Berkus