Re: [GENERAL] Please advise on this trigger function

2016-04-01 Thread Adrian Klaver
On 03/30/2016 01:09 PM, John Stewart wrote: Good day, I have two tables, table1 & table2 with two trigger functions set on table1, on before & after insert. table1 contains a foreign key reference to table2, called building_id. What are the actual schema definitions for the tables? when a r

[GENERAL] Please advise on this trigger function

2016-04-01 Thread John Stewart
Good day, I have two tables, table1 & table2 with two trigger functions set on table1, on before & after insert. table1 contains a foreign key reference to table2, called building_id. when a row is inserted into table1, building is in text format, I need the after-trigger to lookup this text valu