How to set a Default Value

From: Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to set a Default Value
Date: 2006-01-13 13:10:05
Message-ID: 20060113131005.16064.qmail@web36712.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi

I have created a column item varchar(11) with default
value = 0

But when i do insert any record the value is set to
null.

How can i always get the defualt value if any other
value is not defined (sometimes it will have some
identification characters)

Thank´s in advance

Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo(at)yahoo(dot)com(dot)br



_______________________________________________________
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-13 13:28:30 Re: How to set a Default Value
Previous Message me 2006-01-13 12:39:08 Re: storing record-array in varchar?