Postgres Pro
Downloads
Home   >   mailing lists

Re: inserting a value as null - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: inserting a value as null
Date
Msg-id 1140433063.12046.11.camel@linda.lfix.co.uk
Whole thread Raw
In response to inserting a value as null  ("Zouari Fourat" <fourat@gmail.com>)
List pgsql-novice
Tree view 
On Mon, 2006-02-20 at 11:31 +0100, Zouari Fourat wrote:
> How can i insert or update a value as NULL ?

Use the keyword NULL instead of a constant or variable.

For example:

  UPDATE mytable SET mycol = NULL;

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html

pgsql-novice by date:

Previous
From: "Zouari Fourat"
Date:
Subject: inserting a value as null
Next
From: Bruno Wolff III
Date:
Subject: Re: Restoring SQL Databse for use in PostgreSQL.