Thanks everyone. I will have the programming language do the work on this one instead of going the trigger route. On Nov 11, 2014 7:39 PM, "Richard Hipp" <d...@sqlite.org> wrote:
> On Tue, Nov 11, 2014 at 8:22 PM, Igor Tandetnik <i...@tandetnik.org> > wrote: > > On 11/11/2014 6:15 PM, Ben Newberg wrote: > > > > Looks like a bug to me. The statement works standalone, but not within a > > trigger. > > > > There are many limitations and restrictions on the statements inside of > triggers. See the trigger documentation ( > https://www.sqlite.org/lang_createtrigger.html) for details. It looks > like > I need to add "no CTEs" to the list of restrictions. > > This is not a bug - it is an intentional omission. A lot of extra code > would need to be added to support this and that is not something we want to > do right now. > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users