[sqlite] SELECT 0 gives TEXT instead of INTEGER

[Cecil Westerhof]

2016-04-21 12:39 GMT+02:00 Dave Wellman <dwellman at ward-analytics.com>:

> How about something like:
>
> WITH RECURSIVE
> expansion(byte) AS (
>     SELECT 0
>     UNION  ALL
>     SELECT byte + 1 FROM expansion
>     LIMIT  10
> )
> SELECT PRINTF('%02d',byte)
> FROM   expansion
> ;
>

?Yes, that is exactly what I want. Thanks.

-- 
Cecil Westerhof