> > 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???
