Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 460C92E0105 for ; Thu, 29 Nov 2007 09:48:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 72942-06 for ; Thu, 29 Nov 2007 09:48:44 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id CA21B2E00F7 for ; Thu, 29 Nov 2007 09:48:48 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so1529895nfh for ; Thu, 29 Nov 2007 05:48:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=gxrdzG43IjNut4W4jKfEd1A0lHkB/NQ71maPub1HN1s=; b=URuHfEj7AFIG8tdt8toveyRY+uuySJUhbiPAzVVEQmY6Di7J31WcF4lVV9X8a8dsMB/EpwEej1Q0s+GhyPqQ85xNYLlxSrULwn/e0leXaJKlK+H27tNkKcndxoKfeGkDUoBksaVT9hUiM/3SexMIUTIcpBBOAVP2I4waKaL3Jb4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sVLRnLtm1mvNrcrApB412Kftt5KIcV1DBRk1eWciCyaVIWoGOGd6bma3i6nhGumvSM55CAYJb4fsI2E4TjUsaNSpXWanausjkOOo9+fsyPpcRbyp0vPgr4sskA1In692Zw0RufzoXRcNDvogb4+Z7IqPx1/KESRpobIwQgGGdZA= Received: by 10.78.140.17 with SMTP id n17mr6905802hud.1196344126727; Thu, 29 Nov 2007 05:48:46 -0800 (PST) Received: by 10.78.35.7 with HTTP; Thu, 29 Nov 2007 05:48:46 -0800 (PST) Message-ID: <162867790711290548t2a050d59ta77595c2b05d59ce@mail.gmail.com> Date: Thu, 29 Nov 2007 14:48:46 +0100 From: "Pavel Stehule" To: "Christian Kindler" Subject: Re: statement-level trigger sample out there? Cc: pgsql-sql@postgresql.org In-Reply-To: <20071129130159.110470@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071129130159.110470@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/153 X-Sequence-Number: 29681 Hello You cannot to access to values in statement trigger. Postgres doesn't support it. Regards Pavel Stehule On 29/11/2007, Christian Kindler wrote: > Hi > > Can anyone provide me a simple example of a statement-level trigger? Problem is I do not know how to access the old.*, new.* values. > > Thanks > Chris > -- > GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. > Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >