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