Numeric Data Type

From: "Huy Do" <huy(at)travel(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Numeric Data Type
Date: 2000-12-22 22:55:39
Message-ID: NEBBIHDFCLBAILBDEADCOECDCAAA.huy@travel.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Mike Hammonds 2000-12-26 15:43:44 Null and Not Null
Previous Message Nabil Sayegh 2000-12-22 14:12:58 Re: error "11"