Re: Type conversion

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Ice Planet <ice(at)adiemus(dot)sk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Type conversion
Date: 2000-07-10 14:24:32
Message-ID: 3969DCA0.25B4783E@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-07-10 15:11:51 Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...
Previous Message Bruce Momjian 2000-07-10 13:27:29 Re: Corruption... please help