Re: How to set a Default Value

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: =?ISO-8859-1?B?wg==?=ngelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to set a Default Value
Date: 2006-01-13 13:29:38
Message-ID: BFED1572.3A81%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 1/13/06 8:10 AM, "Ângelo Marcos Rigo" <angelo_rigo(at)yahoo(dot)com(dot)br> wrote:

> 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 are you defining your table and doing your insert?

Sean

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Christian Hofmann 2006-01-13 15:32:32 Setting a variable for current session (set, define or something) for auditing
Previous Message Michael Glaesemann 2006-01-13 13:28:30 Re: How to set a Default Value