Hi Tirumala, I don't know if you can get that value from "NEW". NEW is a variable that corresponds to the record that you were inserting when the trigger fired. Would you mind sharing a bit more information about your current task? E.g. can you show the DDL for all the tables that are involved here?
Cheers, Lukas 2015-10-08 15:06 GMT+02:00 <[email protected]>: > We have another problem by creating normal sequence which actually full > fills my requirement. So as per your reply i can get NEW.CW_DOCTYPE_ID in > the function right?? > if it is, My actual insertion is happening from java.. can i get recent > CW_DOCTYPE_ID from NEW.CW_DOCTYPE_ID?? > > On Thursday, 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. > -- 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.
