Postgres Pro
Downloads
Home   >   mailing lists

Re: declare column update expression - Mailing list pgsql-general

From Chris Velevitch
Subject Re: declare column update expression
Date
Msg-id b0a3bf780809110804w5beab20ct4e5d17a7fcc0edde@mail.gmail.com
Whole thread Raw
In response to Re: declare column update expression  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: declare column update expression  (Artacus <artacus@comcast.net>)
Re: declare column update expression  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view 
On Thu, Sep 11, 2008 at 6:01 PM, Pavel Stehule <pavel.stehule@gmail.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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: "Healing" a table after massive updates
Next
From: Magnus Hagander
Date:
Subject: European PGDay 2008 - registration open