Re: [PgFoundry] Unsigned Data Types [1 of 2]

On Mon, Sep 15, 2008 at 9:45 PM, Ryan Bradetich <rbradetich(at)gmail(dot)com> wrote:
>>
>> I have the code and regression tests updated to solve the problems you initially
>> discovered. After code reading, stepping through with the debugger, and
>> help from RhodiumToad on irc I was able to implement new restrict
>> selective estimation
>> functions for the uint4 vs int4 data types. The uint1 vs int4 and
>> uint2 vs int4 data
>> types did not require a custom restrict selective estimation function.
>>

i'm still seeing the failures in the copy commands (the ones about the paths)

i'm not really sure if this matters.

contrib_regression=# select 256::int2::int4;
int4
------
256
(1 row)

contrib_regression=# select 256::uint2::int4;
int4
------
256
(1 row)

contrib_regression=# select 256::int2::uint4;
ERROR: cannot cast type smallint to uint4 at character 17
STATEMENT: select 256::int2::uint4;
ERROR: cannot cast type smallint to uint4
LINE 1: select 256::int2::uint4;

otherwise seems fine

--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157