Re: getting type name

From: Tzahi Fadida <Tzahi(dot)ML(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: getting type name
Date: 2006-07-09 23:03:11
Message-ID: 200607100203.12137.Tzahi.ML@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2006-07-10 03:00:52 pgsql-patches considered harmful
Previous Message Mark Kirkwood 2006-07-09 23:02:58 Statement Queuing