Christopher,

> In the bad old days when we couldn't distinguish explicit from implicit
> cast functions, I was wary of adding new cast pathways.  Too many
> implicit casts and you have no type system at all.  But in 7.3 there
> should be no reason to object to an explicit-only cast from numeric
> to text or vice versa.

I'd suggest making the explicit cast of numeric to text be the exact 
equivalent of:

SELECT btrim(to_char(numeric, '999,999,999,999.9999999999'))
or similar.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to