pg.ddx.io  pgsql-patches@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jaime Casanova <jcasanov@systemguards.com.ec>
To: Ryan Bradetich <rbradetich@gmail.com>
Cc: pgsql-patches <pgsql-patches@postgresql.org>
Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
Date: Sun, 21 Sep 2008 19:29:17 -0500
Message-ID: <3073cc9b0809211729s50054a85kfb95925307a08442@mail.gmail.com> (raw)
In-Reply-To: <e739902b0809151945v16fe3af0pe78b2cb133d94c91@mail.gmail.com>
References: <e739902b0808311335l1ad5d425r2704429c386f2f88@mail.gmail.com>
	<3073cc9b0809062330o62fd74dax74b1730cedc0fbb9@mail.gmail.com>
	<e739902b0809082008p6c694a20ufd526d1ce5d46750@mail.gmail.com>
	<3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com>
	<e739902b0809082325s69c21814mbc0dc8dfd6ebfec6@mail.gmail.com>
	<22555.1220962305@sss.pgh.pa.us>
	<e739902b0809090814j55a75d6dm213432b87f4b0c5f@mail.gmail.com>
	<e739902b0809100803jc35798fga19b3e77019422fa@mail.gmail.com>
	<e739902b0809150813x7e3e2af6s4174197efd5d3070@mail.gmail.com>
	<e739902b0809151945v16fe3af0pe78b2cb133d94c91@mail.gmail.com>

On Mon, Sep 15, 2008 at 9:45 PM, Ryan Bradetich <rbradetich@gmail.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



view thread (26+ messages)  latest in thread

Message-ID: <3073cc9b0809211729s50054a85kfb95925307a08442@mail.gmail.com>
Permalink:  ../3073cc9b0809211729s50054a85kfb95925307a08442@mail.gmail.com/
Also on:    postgresql.org/message-id/3073cc9b0809211729s50054a85kfb95925307a08442@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-patches@postgresql.org
  Cc: jcasanov@systemguards.com.ec, rbradetich@gmail.com
  Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
  In-Reply-To: <3073cc9b0809211729s50054a85kfb95925307a08442@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox