I've been looking through the material I have on postgreSQL, but can't seem
to find an answer to my problem. Very simplied, my tables are something like
this:
create table news (
id serial,
story text,
publishtime timestamp
)
create table news_unpublished (
news_id
)
I wish to make rule looking something like this:
create rule newsrule as
on insert to news do
if new.publishtime is not null insert into news_unpublished
values(new.id);
I.e. "On an insert to news, if new.publish is not null, insert the new
post's id into news_unpublished.
Is this possible?
Thanks
André Næss