Re: Unsigned ints (Help) - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Unsigned ints (Help)
Date
Msg-id 3AC208E4.70B4AF6C@alumni.caltech.edu
Whole thread Raw
In response to Unsigned ints  (Adriaan Joubert <a.joubert@albourne.com>)
List pgsql-hackers
> At this point I decided that somewhere in the definition of the type
> there must be a way of specifying how values can be transformed. Can
> anybody explain to me what I need to change to make this work? Without
> this ecpg cannot work with unsigned ints, so explicit casting is not an
> option.

The large integer-like value is silently transformed into a float8 by
the scanner (very early in the parsing stage). You have not provided a
function to transform float8 into uint4, which if you do so will fix
your problem. Do a
 create function uint4(float8)...

and the type coersion code will understand how to convert one into the
other.
                    - Thomas


pgsql-hackers by date:

Previous
From: Joel Burton
Date:
Subject: Re: Feature Request: ALTER FUNCTION (or something like that)
Next
From: Tom Lane
Date:
Subject: Re: Unsigned ints (Help)