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: (view raw or whole thread)
Lists: pgsql-novice

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

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

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


Yahoo! doce lar. Faça do Yahoo! sua homepage. 


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-2015 The PostgreSQL Global Development Group