Re: [GENERAL] Strange behavior of insert CTE with trigger

2015-04-01 Thread David G. Johnston
On Fri, Mar 27, 2015 at 4:18 PM, Anil Menon wrote: > Hi, > > I am trying to wrap my head around a strange problem I am having. I have > double checked the documentation but I could not find anything on this. > > ​[...]​ > > However I get no rows returned from the select statement- looks the >

[GENERAL] Strange behavior of insert CTE with trigger

2015-03-31 Thread Anil Menon
Hi, I am trying to wrap my head around a strange problem I am having. I have double checked the documentation but I could not find anything on this. I am attaching a simplified version of my problem. I my TEST 4 I expect 1 row but I get nothing. The test is with I(id) as ( insert into abc(colD