Re: Type conversion - Mailing list pgsql-sql

From Thomas Lockhart
Subject Re: Type conversion
Date
Msg-id 3969DCA0.25B4783E@alumni.caltech.edu
Whole thread Raw
In response to Type conversion  (Ice Planet <ice@adiemus.sk>)
List pgsql-sql
> 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


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Corruption... please help
Next
From: Dorin Grunberg
Date:
Subject: Subselects with IN and EXISTS