[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: Indices starting from non-1 (Was: Killa: a scripting language ...)
- From: Egor Skriptunoff <egor.skriptunoff@...>
- Date: Fri, 1 Mar 2013 00:24:49 +0300
On Thu, Feb 28, 2013 at 10:55 PM, Marc Balmer <firstname.lastname@example.org> wrote:
> Since I do a lot of database programming in Lua, I would very much welcome an integer data type.
Would it be really helpful?
Not all database engines are integer-friendly.
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.