Just because we can:
with
Option( name, position )
as
(
select sqlite_compileoption_get( 1 ) as name,
1 as position
union all
select sqlite_compileoption_get( position + 1 ) as name,
position + 1 as position
from Option
where sqlite_compileoption_get( position + 1 ) is not null
)
select name
from Option
order by name
> ENABLE_FTS3_PARENTHESIS
> ENABLE_RTREE
> ENABLE_STAT4
> SYSTEM_MALLOC
> THREADSAFE=1
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
