You are missing one value. To get all the values, start from 0:
with
Option( name, position )
as
(
select sqlite_compileoption_get( 0 ) as name,
0 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
Bogdan Ureche
On Sat, Mar 1, 2014 at 9:01 AM, Petite Abeille <[email protected]>wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
