Re: getting type name

On Monday 10 July 2006 00:29, Martijn van Oosterhout wrote:
> 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?

Just if it is a one-to-one conversion, otherwise the same type
equality functions i use would potentially not work properly.

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

--
Regards,
        Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS:  see at
http://members.lycos.co.uk/my2nis/spamwarning.html