Weird type selection choice

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Weird type selection choice
Дата
Msg-id 200711061631.06129.peter_e@gmx.net
обсуждение исходный текст
Ответы Re: Weird type selection choice  (Bernd Helmle <mailings@oopsware.de>)
Re: Weird type selection choice  (Peter Eisentraut <peter_e@gmx.net>)
Re: Weird type selection choice  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Weird type selection choice  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
I noticed this problem in 8.2 and 8.3:

pei=# select mod( trunc( 1 ), 2 );
ERROR:  42883: function mod(double precision, integer) does not exist
LINE 1: select mod( trunc( 1 ), 2 );              ^

It apparently casts the 1 to double precision to pick the variant 
trunc(dp)=>dp instead of trunc(numeric)=>numeric.  I was under the impression 
that we didn't want to cast integers to float types implicitly because this 
loses information.  Clearly, the numeric variant should be preferred anyway.  
What's wrong here?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: should I worry?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: regtype sorting broken in 8.3