Skip site navigation (1) Skip section navigation (2)

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

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: "Ryan Bradetich" <rbradetich(at)gmail(dot)com>
Cc: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
Date: 2008-09-22 00:29:17
Message-ID: 3073cc9b0809211729s50054a85kfb95925307a08442@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-patches
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

In response to

Responses

pgsql-patches by date

Next:From: Ryan BradetichDate: 2008-09-22 05:30:34
Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
Previous:From: Tom LaneDate: 2008-09-19 20:14:16
Subject: Re: [PATCHES] libpq events patch (with sgml docs)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group