DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=qYYCsDeG+UhBXvYPtd9JAuhGwT+j9lKsRicZjNCAyJq0fcVeZj/ki5um5/3an9EixOvvE53qat0hW4tvGI78NN4cRFmVEEl4/WHuVm6TBisrbxhUCCHzoMAtQTuibocvr3fzTbioAFYxkGMpvQQ7VyeOF9zovheNGP882LG4TVI=
Message-ID: <396486430805070623p360b8eafp39683a287cdb3cc@mail.gmail.com>
Date: Wed, 7 May 2008 06:23:04 -0700
From: "Richard Broersma" <richard.broersma@gmail.com>
To: "Michael Monnerie" <michael.monnerie@it-management.at>
Subject: Re: column: on update update?
Cc: pgsql-admin@postgresql.org
In-Reply-To: <200805071050.41450@zmi.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <200805071050.41450@zmi.at>

On Wed, May 7, 2008 at 1:50 AM, Michael Monnerie
<michael.monnerie@it-management.at> wrote:
> But I also need the "lastupdate" be updated every time a field in that
> row is updated, so a statement like this:
>
> But it doesn't work. Do I need a trigger? If yes, what would be the
> format? I never did triggers.

Well you have two options.  The perferred method would be to have your
application include an update to your lastupdate field whenever
anyother rows are updated.

UPDATE awl
    SET lastupdate = CURRENT_TIMESTAMP,
             ....,
WHERE ....;

the other option is to add an after update trigger, and manually set
lastupdate then.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug