X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 01C4B52906
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 15 Aug 2005 00:22:04 -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 59697-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 15 Aug 2005 03:22:02 +0000 (GMT)
Received: from alvh.no-ip.org (200-85-218-206.bk4-dsl.surnet.cl
	[200.85.218.206])
	by svr1.postgresql.org (Postfix) with ESMTP id 9EDC552DE1
	for <pgsql-sql@postgresql.org>; Mon, 15 Aug 2005 00:22:00 -0300 (ADT)
Received: by alvh.no-ip.org (Postfix, from userid 1000)
	id B9243C2DC09; Sun, 14 Aug 2005 23:22:30 -0400 (CLT)
Date: Sun, 14 Aug 2005 23:22:30 -0400
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: santiago <chetzacoalt@free.fr>
Cc: pgsql-sql@postgresql.org
Subject: Re: catch an 'update  where false' ?
Message-ID: <20050815032230.GC19959@alvh.no-ip.org>
Mail-Followup-To: santiago <chetzacoalt@free.fr>,
	pgsql-sql@postgresql.org
References: <EKEMKEFLOMKDDLIALABIGEEFCBAA.lvaningen@esncc.com>
	<42FF436B.8030701@free.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42FF436B.8030701@free.fr>
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.737 required=5 tests=[AWL=0.313,
	DNS_FROM_RFC_ABUSE=0.374, FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200508/90
X-Sequence-Number: 22318

On Sun, Aug 14, 2005 at 03:13:15PM +0200, santiago wrote:

> according to my book, triggers are only implemented whit the FOR EACH
> ROW clause in postgres, and not available in the FOR EACH STATEMENT
> case. has this changed in some new version ? which shall I use then ?

Yes, it was added in release 7.4.

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
<Schwern> It does it in a really, really complicated way
<crab> why does it need to be complicated?
<Schwern> Because it's MakeMaker.