From: | Kareem Sedki <isiscreation(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to check whether a data type can be cast to another |
Date: | 2009-10-23 08:38:27 |
Message-ID: | 4AE16B83.1020501@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all,
I am trying to write a function that takes one source and one target
data type identifiers, each as a '/text/' variable, as arguments and
return true if the cast can be made, false otherwise.
I consulted the pg_cast and pg_type tables, however, I found no direct
casts from 'int4' to 'text'. Even though, you SELECT CAST(4::int4 AS
text) The possibility of indirect casts that use multiple intermediate
casts is slim - to me. Is an 'int4' cast to 'text' by means of multiple
intermediate casts from 'int4' to 'char' and eventually to 'text'?
I would prefer to have a function written in PG/PLSQL for now as we are
prototyping the system. Could someone help me write such a function,
please?
Thank you in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Raimon Fernandez | 2009-10-23 09:25:44 | Re: Implementing Frontend/Backend Protocol |
Previous Message | Sydney Puente | 2009-10-23 06:45:05 | drop view and recreate - for sync |