>>> Alvaro Herrera <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to