numeric data type - Mailing list pgsql-novice

From Corey
Subject numeric data type
Date
Msg-id 200611160613.41212.corey@bitworthy.net
Whole thread Raw
Responses Re: numeric data type  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: numeric data type  ("Phillip Smith" <phillips@weatherbeeta.com.au>)
List pgsql-novice
I've got the following:

cc_exp_month numeric(2,0)


So that I could input '06', for instance -- however the 0 doesn't make it's
way into the column... I get '6' instead.

I want to constrain this in the db, which is why I don't just use:

cc_exp_month integer


My question: what do I need to do to have the constraint ( two digits ) work,
while still keeping the extra 0?


Thanks.


pgsql-novice by date:

Previous
From: "Guido Barosio"
Date:
Subject: Re: can i install and run two diferent versions of postgresql
Next
From: Nelly Rodríguez
Date:
Subject: unsuscribe