On Thu, 2004-08-26 at 00:52, Justin Wyer wrote:
> A trigger is the correct way.
> Check out the PostgreSQL documentation it is quite comprehensive.
Justin is right.
What you'll need to do is create a function that modifies that mod_date
column and the create a trigger to call it whenever that record is
Here's an example that I think might work for you:
CREATE FUNCTION my_date_modified() RETURNS trigger AS '
NEW.mod_date := ''now'';
' LANGUAGE plpgsql;
CREATE TRIGGER my_date_mod BEFORE INSERT OR UPDATE ON table
FOR EACH ROW EXECUTE PROCEDURE my_date_modified();
For this example, you'd need to have the plpgsql language installed on
your database if it isn't already:
shell> createlang plgsql dbname
Gene Stevens <gene(at)triplenexus(dot)org>
In response to
pgsql-php by date
|Next:||From: Gerard Samuel||Date: 2004-08-26 20:36:25|
|Subject: Space requirements (with respect to foriegn languages)|
|Previous:||From: Justin Wyer||Date: 2004-08-26 06:52:03|
|Subject: Re: Mod_date update technique|