Re: getting type name

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tzahi Fadida <Tzahi(dot)ML(at)gmail(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: getting type name
Date: 2006-07-09 21:29:29
Message-ID: 20060709212929.GF4954@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2006-07-09 23:02:58 Statement Queuing
Previous Message Tzahi Fadida 2006-07-09 19:08:42 Re: getting type name