Re: getting type name

On Sun, Jul 09, 2006 at 10:08:42PM +0300, Tzahi Fadida wrote:
> They return format_type_be(INT4OID) = "integer" or format_type_be(FLOAT8OID)
> = "double precision"
> I need to use this in a query with the "::" cast operator.

The problem being?

test=# select '1'::integer, '4.5'::double precision;int4 | float8
------+--------   1 |    4.5
(1 row)

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.