| From: | Jeff Williams <jeffw(at)globaldial(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Update timestamp on update |
| Date: | 2005-10-13 01:12:34 |
| Message-ID: | 434DB482.1000205@globaldial.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-sql |
I have a table like:
CREATE TABLE products (
id int,
status int,
last_status_change timestamp DEFAULT now()
);
What I would like is that whenever the status is changed the
last_status_change timestamp is updated to the current time. I have had
a look at the rules and what I want would be similar to:
CREATE RULE last_status_change AS ON UPDATE
TO products WHERE NEW.status <> OLD.status
DO UPDATE products SET last_status_change = now() WHERE id = OLD.id;
Except of course that the above is recursive and doesn't work.
How can I do this?
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-13 01:44:49 | Re: Update timestamp on update |
| Previous Message | Bruce Momjian | 2005-10-12 14:55:17 | Re: COPY example for partial tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2005-10-13 01:13:29 | Re: pg, mysql comparison with "group by" clause |
| Previous Message | Tom Lane | 2005-10-12 23:00:05 | Re: Text->Date conversion in a WHERE clause |