BUG #4114: Inconsistent ****ft operator

The following bug has been logged online:

Bug reference:      4114
Logged by:          Roman Kononov
Email address:      kononov@[EMAIL PROTECTED]
 version: 8.3.1
Operating system:   x86_64 GNU/Linux
Description:        Inconsistent ****ft operator
Details: 

The below test cases show the obvious inconsistency between different
integer types.

test=# \t
Showing only tuples.
test=# select 1::int2 << 17;
         0

test=# select 1::int4 << 33;
         2

test=# select 1::int8 << 65;
         2

test=# select 2::int2 >> 17;
         0

test=# select 2::int4 >> 33;
         1

test=# select 2::int8 >> 65;
         1

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs