hmm.. Conseguir fazer funcionar, da seguinte maneira:
CREATE OR REPLACE FUNCTION users_code_seq() > RETURNS "trigger" AS $$ > BEGIN > > IF (TG_OP = 'INSERT') THEN > UPDATE public.company_seqs SET last_seq = (last_seq + 1) WHERE > company_id = NEW.company_id; > > END IF; > > IF NEW.code IS NULL THEN > SELECT last_seq INTO NEW.code FROM public.company_seqs WHERE > company_id = NEW.company_id ORDER BY last_seq DESC; > > END IF; > > RETURN NEW; > > END; > $$ LANGUAGE plpgsql; Eu estava fazendo o ELSEIF errado.. Obrigado
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
