Kevin Grittner escribió: > >>> 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.
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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
