On May 13, 2013, at 6:12 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> I should have asked you for (1,2,20) as well and we could see whether it > outputs '10' or '10.0'. But yes, it would appear that in Oracle, NUMERIC > means FLOAT. Nah. Plus there is no such type as 'NUMERIC' per se in Oracle. Just NUMBER( precision, scale ) or… FLOAT( precision ). (ignoring binary types for simplicity's sake). http://docs.oracle.com/cd/E11882_01/server.112/e17118/sql_elements001.htm#sthref118 A so-called 'integer' in Oracle is simple a number defined as NUMBER(p,0). Th ANSI names such as NUMERIC(19,0), or DECIMAL(p,s), etc… are aliases for the relevant Oracle types, e.g. NUMBER(19,0). Anyhow… none of this helps SQLite much… :P _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users