On Wed, Mar 6, 2013 at 4:20 PM, Petite Abeille <petite.abei...@gmail.com> wrote: > All good. Small sanity check though: > > > select 2 = cast( '2' as integer ); >> 1 > > Ok… '2' is can be casted to 2… great... > > > select 2 = cast( 'a2' as integer ); >> 0 > > Ok… 'a2' cannot really be casted to an integer… cool... > > > select 2 = cast( '2.1' as integer ); >> 1 > > Hmmm…. > > > select 2 = cast( '2abc' as integer ); >> 1 > > Whaaaaat?!? Oh… "When casting a TEXT value to INTEGER, the longest possible > prefix of the value that can be interpreted as an integer number is extracted > from the TEXT value and the remainder ignored. "… ah… ok… weird… > > So… > > select cast( 'abc' as integer ); >> 0 > > o k i d o k i . . .
Oh. Oh.. Ew.. Never mind then! Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users