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

From Artacus
Subject Re: declare column update expression
Date
Msg-id 48C9D908.7090007@comcast.net
Whole thread Raw
In response to Re: declare column update expression  ("Chris Velevitch" <chris.velevitch@gmail.com>)
Responses Re: declare column update expression  ("Chris Velevitch" <chris.velevitch@gmail.com>)
Re: declare column update expression  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
> How is it that you can declare the default value of a column on insert
> but not on update?

You can do this without triggers (at least on 8.3).

UPDATE foo
SET field1  = 2,
    field2 = default
WHERE field3 = 22

I just tested it and it will set the value back to the default. The
caveat here is that it won't FORCE the value like it would with a
trigger. So while the trigger would happen automatically, using this
approach, you'd have to remember to also update that field any time you
did an update.

Artacus


pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: connection timeouts and "killing" users
Next
From: "Chris Velevitch"
Date:
Subject: Re: declare column update expression