Re: declare column update expression

From: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: declare column update expression
Date: 2008-09-11 15:04:10
Message-ID: b0a3bf780809110804w5beab20ct4e5d17a7fcc0edde@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 11, 2008 at 6:01 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> you should to use trigger

I've never used trigger before, it looks messy and error prone having
to write functions.

How is it that you can declare the default value of a column on insert
but not on update?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-09-11 15:08:09 European PGDay 2008 - registration open
Previous Message Bill Moran 2008-09-11 14:56:56 Re: "Healing" a table after massive updates