datatype matrix (was: Re: Sorry..)
От | Kevin Brannen |
---|---|
Тема | datatype matrix (was: Re: Sorry..) |
Дата | |
Msg-id | 3D3459C0.20209@nurseamerica.net обсуждение исходный текст |
Ответ на | Sorry.. ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Ответы |
Re: datatype matrix (was: Re: Sorry..)
Re: datatype matrix (was: Re: Sorry..) |
Список | pgsql-sql |
Josh Berkus wrote: > 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. > In this vain, is there someplace in the docs that has a type conversion table (matrix) that shows what datatype can be cast into what other datatype (both implicitly and explicitly)? I haven't seen one and it would be helpful for us newbies. Thanks! Kevin
В списке pgsql-sql по дате отправления: