How to setup a column constraint for an integer type? Default 0 if not defined

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to setup a column constraint for an integer type? Default 0 if not defined
Date: 2010-04-02 01:18:55
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC0457D933D9@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm trying to port some source code to Postgres 8.3.8 and have been encountering some surprises :-(
I would like to set up a column constraint for an integer type, so that when the value is undefined, it would assign a default value of 0 to that column.
How would I do that in 8.3.8? Please provide an example.

Mary

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-04-02 01:51:48 Re: How to setup a column constraint for an integer type? Default 0 if not defined
Previous Message Filip Rembiałkowski 2010-04-01 23:45:08 Re: Accessing Windows install of PostgreSQL via cygwin