Re: Examples of SQL anomalies?
From: Marshall <marshall.spight_at_gmail.com>
Date: Thu, 3 Jul 2008 08:14:38 -0700 (PDT)
Message-ID: <7578f7f6-970e-4b7a-993a-3dd9d7ef8ab0_at_a32g2000prf.googlegroups.com>
> For fixed-size integer values, there are no implementation
> difficulties.
> However, I'm not sure that semantically, this is entirely what we
> want, even though there is the very strong argument that the
> smallest int is the identity for the operation.
Date: Thu, 3 Jul 2008 08:14:38 -0700 (PDT)
Message-ID: <7578f7f6-970e-4b7a-993a-3dd9d7ef8ab0_at_a32g2000prf.googlegroups.com>
On Jul 3, 7:48 am, Marshall <marshall.spi..._at_gmail.com> wrote:
>
> For fixed-size integer values, there are no implementation
> difficulties.
> However, I'm not sure that semantically, this is entirely what we
> want, even though there is the very strong argument that the
> smallest int is the identity for the operation.
Meh, on thinking about it further, this is no more problematic than something like MAXINT+1=MININT. If one is using modular arithmetic, one shouldn't expect regular arithmetic.
Marshall Received on Thu Jul 03 2008 - 17:14:38 CEST