>
> 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;
>
>         ELSEIF NEW.code IS NULL THEN
>         SELECT last_seq INTO code FROM public.company_seqs WHERE
> company_id = NEW.company_id ORDER BY last_seq DESC;
>
>         END IF;
>
>         RETURN NEW;
>
> END;
> $$ LANGUAGE plpgsql;


- The command above, does not insert the last_seq into users.code column.
And I don't know why.


If I comment the line: *ELSEIF NEW.code IS NULL THEN*, the data is inserted
into the users.code column.

But as the customer can add data into that column, I only insert the
last_seq if he/she didn't insert anything.

So I need that *ELSEIF NEW.code IS NULL THEN*.

- What am I missing?

Thanks
Lucas

Reply via email to