numeric data type

From: "Corey" <corey(at)bitworthy(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: numeric data type
Date: 2006-11-16 13:13:41
Message-ID: 200611160613.41212.corey@bitworthy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nelly Rodríguez 2006-11-16 20:20:20 unsuscribe
Previous Message Guido Barosio 2006-11-16 00:59:04 Re: can i install and run two diferent versions of postgresql