Postgres Pro
Downloads
Home   >   mailing lists

Esay question, about the numeric format - Mailing list pgsql-general

From Rafa Comino
Subject Esay question, about the numeric format
Date
Msg-id bd8b58a40702220320l73b09f23l4a4c6a0c198b0f49@mail.gmail.com
Whole thread Raw
Responses Re: Esay question, about the numeric format  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Esay question, about the numeric format  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: CaT
Date:
Subject: Re: Checking for string data that makes sense Re: postgresql vs mysql
Next
From: "A. Kretschmer"
Date:
Subject: Re: Esay question, about the numeric format