Re: entering empty value

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: entering empty value
Date: 2002-02-21 03:43:41
Message-ID: slrna78r3i.75.missive@whave.frontiernet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I have a table with records where sometimes a value should be kept empty
> e.g. faxnumber is sometime empty because not everybody owns a fax. What
> is the syntax for entering the data for such a record with an empty
> value?
>

create table t (a int, b text);

insert into t values(1, NULL)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2002-02-21 03:44:51 Re: deleting an identical record
Previous Message pauLSiew 2002-02-21 02:44:30 Date problem