Yes I have tried with t_ix = 1; or t_ix := 1; I get the same result, it just
doesn't do anything, I have also tried with AFTER and BEFORE, when I use
BEFORE I get this error ERROR: cannot return non-composite value from
function returning composite type CONTEXT: PL/pgPSQL function
on_ai_mytable() line 17 at RETURN <<<<<<<<< line 17 is... "NEW.time_index =
t_ix;"
--
View this message in context: http://postgresql.nabble.com/INSERT-a-number-in-a-column-based-on-other-columns-OLD-INSERTs-tp5854577p5854581.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.