Re: declare column update expression

 > That means I have to then go through all my code and make sure I set
 > the fields value. If I forget to modify one statement, things will
 > break.

Right, that's why the right answer for what you want to do is to have a
trigger. I was just giving you an alternative since you didn't like the
trigger answer.


> Do you have a superuser account?  Pretty sure you gotta have that to
> create lang.  OTOH, plpgsql is a "safe" language once installed, so
> you should be able to ask your hosting provider to install it.  Can't
> hurt to ask.

For plpgsql I don't believe it actually "installs" anything. The docs
make it sound more like it activates it. So as long as you own your
database you should be able to

createlang plpgsql