Re: Displaying a float8 as a full-length number

From: "Julie May" <julie(at)ccorb(dot)com>
To: "Grant Rutherford" <grutherford(at)iders(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Displaying a float8 as a full-length number
Date: 2003-10-08 18:04:30
Message-ID: 014e01c38dc6$9eedc710$a1d2a8c0@impsu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grant,

Cast it to numeric instead of float8.
SELECT CAST('0.00001' AS numeric);

Julie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2003-10-08 18:05:47 Re: PostgreSQL vs. MySQL
Previous Message Richard Lough 2003-10-08 18:01:04 Virtual Machines and postgres