[sqlite] Regarding root in transitive closure extension of SQLite

> Hello ! > > Look this comment on ext/misc/closure.c: > > -- > > ** When it is created, the new transitive_closure table may be supplied > ** with default values for the name of a table T and columns T.X and T.P. > ** *The T.X and T.P columns must contain integers*. The ideal case is > for >

[sqlite] Regarding root in transitive closure extension of SQLite

> > Given that SQLite supports CTE's now, why use that extension? > > AFAIK, it was to add hierarchical query capability to SQLite, which CTE > does builtin now. --DD But will that solve my problem of having the data type of groupId other than Integer primary key like Text???

[sqlite] Regarding root in transitive closure extension of SQLite

I have enabled the transitive closure extension and I followed the steps regarding querying the virtual table mentioned in closure.c file as follows CREATE VIRTUAL TABLE ct1 USING transitive_closure( tablename='group1', idcolumn='groupId', parentcolumn='parentId' ); CR

[sqlite] Regarding root in transitive closure extension of SQLite

On Thu, Aug 6, 2015 at 8:55 AM, Sairam Gaddam wrote: > I have enabled the transitive closure extension and I followed the steps > regarding querying the virtual table mentioned in closure.c file as follows > Given that SQLite supports CTE's now, why use that extension? AFAIK, it was to add hier