Re: Refreshing functional index

Hello,

W dniu 2012-08-31 20:25, David Johnston pisze:
> The question becomes how do you update the "item id" on the "groups"
> table when you add new records to "items".

I have a trigger on items table:

CREATE TRIGGER items_insert
BEFORE INSERT
ON items
FOR EACH ROW
EXECUTE PROCEDURE items_oninsert();

CREATE OR REPLACE FUNCTION items_oninsert()
RETURNS trigger AS
$BODY$
BEGIN
UPDATE groups SET last_item = NEW.id WHERE id=NEW.group AND
(last_item IS NULL OR last_item<NEW.id);
RETURN NEW;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

Thanks!

--
Regards,
Grzegorz