Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group