Re: Weird NULL behavior - Mailing list pgsql-sql

From Tom Lane
Subject Re: Weird NULL behavior
Date
Msg-id 28472.1036699251@sss.pgh.pa.us
Whole thread Raw
In response to Re: Weird NULL behavior  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Thu, 7 Nov 2002, Tom Lane wrote:
>> I am kind of inclined to remove the arithmetic operators on "char"
>> (+,-,*,/) in 7.4 --- they don't seem to have any real-world uses,
>> and as this example illustrates, they are perfectly positioned to
>> capture cases that probably ought to be errors.

> That seems to make sense. I assume that they were there so that someone
> could treat it as a 1 byte integer?

Presumably ... but defining a numeric type named "int1" would be a lot
more sensible than overloading "char" for the purpose.
        regards, tom lane


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Weird NULL behavior
Next
From: Jean-Luc Lachance
Date:
Subject: Re: Quartile (etc) ranking in a SQL statement?