Re: Refreshing functional index

"BEFORE INSERT" was the problem here, "AFTER INSERT" works fine

Thanks for all answers.

--
Regards,
   Grzegorz


W dniu 2012-08-31 20:41, Grzegorz Tańczyk pisze:
> 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