lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]

On Feb 28, 2013, at 10:24 PM, Egor Skriptunoff <> wrote:

> In Oracle DB all operations with INTEGER data type are slower than the
> same operations with NUMBER data type.
> This is because INTEGER is a subtype of NUMBER.
> A subtype is actually the same as base type but with additional
> constraints, which should be checked on every step.

( … getting a bit off topic, but... )

Hmmm… not to be picky… but… in Oracle [1]… at the SQL level… there is only one number type (ignoring floats for the sake of argument)… with different levels of precision… and that's that… i.e. 'INTEGER' is an alias for NUMBER( 38 )… 

But perhaps you are thinking about PL/SQL data types? Which is a different kettle of fish altogether… anyhow… this is not helping much with Lua number type :)