Weird type selection choice
От | Peter Eisentraut |
---|---|
Тема | Weird type selection choice |
Дата | |
Msg-id | 200711061631.06129.peter_e@gmx.net обсуждение исходный текст |
Ответы |
Re: Weird type selection choice
Re: Weird type selection choice Re: Weird type selection choice Re: Weird type selection choice |
Список | 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 по дате отправления: