Re: [SQL] Type conversion

[Thomas Lockhart]

> select TheNumberFromConsole/(select max(division_point) from table1)

Try

  select '1234.5678'/(select max(division_point) from table1);

The quotes around the apparent floating point number keeps Postgres from
assuming that it *is* a floating point number, and it later decides that
it must have been a numeric() type.

                        - Thomas