Postgres Pro
Downloads
Home   >   mailing lists

How to set a Default Value - Mailing list pgsql-novice

From Ângelo Marcos Rigo
Subject How to set a Default Value
Date
Msg-id 20060113131005.16064.qmail@web36712.mail.mud.yahoo.com
Whole thread Raw
Responses Re: How to set a Default Value  (Michael Glaesemann <grzm@myrealbox.com>)
Re: How to set a Default Value  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Tree view 
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@yahoo.com.br









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

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: storing record-array in varchar?
Next
From: Michael Glaesemann
Date:
Subject: Re: How to set a Default Value