Re: getting type name - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: getting type name
Date
Msg-id 20060709212929.GF4954@svana.org
Whole thread Raw
In response to Re: getting type name  (Tzahi Fadida <Tzahi.ML@gmail.com>)
Responses Re: getting type name  (Tzahi Fadida <Tzahi.ML@gmail.com>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Tzahi Fadida
Date:
Subject: Re: getting type name
Next
From: Tzahi Fadida
Date:
Subject: Re: getting type name