Kevin Grittner escribió:
> >>> 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.
Sorry, I was unclear. What I meant was that both 0.42 + 1 and
'0.42' + 1 should be treated the same, and they should both produce a
numeric output.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.