-- -- workflow_case__add_token/3 -- create or replace function workflow_case__add_token( integer, character varying, integer ) returns int4 as $$ declare add_token__case_id alias for $1; add_token__place_key alias for $2; add_token__journal_id alias for $3; v_token_id integer; v_workflow_key varchar; begin select wf_token_id_seq.nextval into v_token_id from dual; select workflow_key into v_workflow_key from wf_cases c where c.case_id = add_token__case_id; insert into wf_tokens (token_id, case_id, workflow_key, place_key, state, produced_journal_id) values (v_token_id, add_token__case_id, v_workflow_key, add_token__place_key, 'free', add_token__journal_id); return 0; end;$$ language plpgsql;