I should have mentioned that NEW.id is set to default to nextval('id_seq').
>this is my trigger and function:
>
>CREATE FUNCTION oned_member_num() RETURNS OPAQUE AS '
> BEGIN
> NEW.member_num := NEW.id + date_part('epoch', timestamp
> 'now');
> RETURN new;
> END;'
>LANGUAGE 'plpgsql';
>
>
>CREATE TRIGGER oned_member_num
>BEFORE INSERT
>ON members
>FOR EACH ROW
>EXECUTE PROCEDURE oned_member_num();
>
>I'm not 100% sure that a pl/pgsql function is the best/only solution here.
>Is it overkill, or my only option?