Postgres Pro
Downloads
Home   >   mailing lists

Numeric Data Type - Mailing list pgsql-novice

From Huy Do
Subject Numeric Data Type
Date
Msg-id NEBBIHDFCLBAILBDEADCOECDCAAA.huy@travel.com.au
Whole thread Raw
Responses Re: Numeric Data Type  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-novice
Tree view 
Hi,

Can anyone give me an explanation of the numeric field.

for eg.

does numeric(2,1) mean a number with 2 digits before the decimal point
and 1 after (22.1),

or does it mean a number with a maximum of 2 digits and at least
1 of those digits have to be after the decimal point (2.1)

Thanks.

Huy

pgsql-novice by date:

Previous
From: Charles Curley
Date:
Subject: Re: web interface for postgreSQL-P.S.
Next
From: mig_work@zipmail.com.br
Date:
Subject: Database formats