>>> Alvaro Herrera <alvherre@commandprompt.com> wrote:
> consider
>
> alvherre=# select 0.42 + 1;
> ?column?
> ----------
> 1.42
> (1 ligne)
>
> However, it would be neat if this behaved the same as
>
> alvherre=# select '0.42' + 1;
> ERROR: invalid input syntax for integer: "0.42"
> STATEMENT: select '0.42' + 1;
I wouldn't want the former to fail.
I also wouldn't like these to fail:
select 5000000000 + 1;
select 'abc'::text || 'def'::varchar(3);
-Kevin