Hi Timo
will it work if you select maxval+1 of memberid column for certain
condition, otherwise 0?
Vijay
Timo Tuomi wrote:
> when I add a member it automatically
> inserts a nextval('memberid') into the memberid field ONLY if
> member_role='a_particular_role' otherwise 0.