Thursday, August 28, 2008

[GENERAL] Need help with simple update / insert trigger

I have table sort of like this:

create table snoz (
a bool default false,
b bool default false,
c bool default false
);

I want to set up a trigger so that any time a row is inserted or
updated, the value of c is set to true if a and/or b is true.

How can I do this?

Thanks!

Matt


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: