plpgsql: filter new value's array field
I have a database function that goes like:
how can I filter
how can I filter
new.items? is that a thing in postgres? I tried SELECTing from new.items but that didn't work.