| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: declare column update expression |
| Date: | 2008-09-11 08:01:23 |
| Message-ID: | 162867790809110101x162c5606k3ae3ec6f3ec1612d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
2008/9/11 Chris Velevitch <chris(dot)velevitch(at)gmail(dot)com>:
> In 7.4, how do I declare that a column in a table is to be
> automatically set to the value of some fixed expression whenever a row
> is updated?
>
> Eg column last_modified is always set to current_timestamp
>
you should to use trigger
regards
Pavel Stehule
>
>
> Chris
> --
> Chris Velevitch
> Manager - Adobe Platform Users Group, Sydney
> m: 0415 469 095
> www.apugs.org.au
>
> Adobe Platform Users Group, Sydney
> September meeting: It's Going To Be Brilliant
> Date: Mon 29th September 6pm for 6:30 start
> Details and RSVP on http://apugs2008september.eventbrite.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Artis Caune | 2008-09-11 08:19:24 | Re: plpgsql return select from multiple tables |
| Previous Message | Dean Rasheed | 2008-09-11 07:57:16 | Re: No error when column doesn't exist |