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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
