Re: implicit type conversions - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: implicit type conversions
Date
Msg-id Pine.LNX.4.44.0306051852290.2050-100000@peter.localdomain
Whole thread Raw
In response to implicit type conversions  ("Coby Beck" <coby@vec.com.au>)
List pgsql-general
Coby Beck writes:

> For example, many functions declared on (INTEGER) need to be changed to
> (BIGINT), type (TEXT) is no longer good enough when it is actually an
> integer being passed, things like this.
>
> Is there some kind of global setting or configuration I can modify rather
> than patching things all over the place?  I have mixed feelings on these
> kinds of behind the scenes "favours" but for now I would just like it to
> work...

If you're desperate, you can read up on the system table pg_cast and
modify the column castcontext for the appropriate casting pairs.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Anonymous CVS access
Next
From: Paul Thomas
Date:
Subject: Re: Question about serial vs. int datatypes