Search Postgresql Archives

Esay question, about the numeric format

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-sql@xxxxxxxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
Subject: Esay question, about the numeric format
From: "Rafa Comino" <rafacomino@xxxxxxxxx>
Date: Thu, 22 Feb 2007 12:20:12 +0100
Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=E2/WB4AcGKiGJbFMzxnZzTHzabi+0ii10zF0kIsXyL87JVMkD/gqdq0cljtyFVN5+SYZo0eK2AXmxXmpHkVzjX2efD4Ll6Mp2xRdGQaBAW3QwtcRMc/bvRWsUsC8Llr7F0JPlXtFQHuLjGWxB3FNZ0IqkB9OnR8tTIsCiPqDyGQ=

Hi every body
I have this query
SELECT 20.00::numeric(38,2)
and postgre gives me 20, i need that postgre gives me 20.00
What can i do? i suppose this must be easy, but i dont find how to do ir
thanks every body

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Esay question, about the numeric format
  - From: Bruno Wolff III
- Re: Esay question, about the numeric format
  - From: A. Kretschmer

Prev by Date: Re: Checking for string data that makes sense Re: postgresql vs mysql
Next by Date: Re: Esay question, about the numeric format
Previous by thread: what compression is used in on disk bitmap index implementation
Next by thread: Re: Esay question, about the numeric format
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux