Hai Lukas, Thank you so much for your reply.
CREATE OR REPLACE FUNCTION cwc_documnetsequence_trg() RETURNS trigger AS $BODY$ DECLARE v_seq_id VARCHAR(32) ; v_incrementno integer ; v_currentnext integer ; BEGIN select docnosequence_id into v_seq_id from cw_doctype where cw_doctype_id = '1'; select sum(incrementno+currentnext) into v_currentnext from cw_sequence where cw_sequence_id = v_seq_id; update cw_sequence set currentnext = v_currentnext where cw_sequence_id = v_seq_id; return NEW; END; $BODY$ LANGUAGE plpgsql VOLATILE COST 100; ALTER FUNCTION cwc_documnetsequence_trg() OWNER TO postgres; the above query is to create a function. which i am calling from a trigger. CREATE TRIGGER documnetsequence AFTER INSERT ON cwc_lead FOR EACH ROW EXECUTE PROCEDURE cwc_documnetsequence_trg(); in that procedure i need dynamic cw_doctype_id value from java.. how can i achieve the above senorio.. is there any other way?.. Awaiting for ur response On Thu rsday, October 8, 2015 at 5:47:16 PM UTC+5:30, [email protected] wrote: > > Hai, > > I have a trigger in Postgrresql DB, i want to pass a parameter to the > trigger so that that trigget will execute by considering the parameter.. I > am using JOOQ,Spring.. Can u share any basic example to call trigger or > passing parameter to trigger in JOOQ.. > > Thanking you, > Tirumala. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
