Home > mailing lists

Re: Replace null values - Mailing list pgsql-general

From	John R Pierce
Subject	Re: Replace null values
Date	March 23, 2010 06:17:44
Msg-id	4BA85CEB.4020901@hogranch.com Whole thread Raw
In response to	Re: Replace null values (Nilesh Govindarajan <lists@itech7.com>)
Responses	Re: Replace null values (Nilesh Govindarajan <lists@itech7.com>)
List	pgsql-general

> How to convert zero length string to null ?



UPDATE yourtable SET name=NULL WHERE name='';

From: "A. Kretschmer"
Date: 23 March 2010, 05:56:49
Subject: Re: Create a function that updates the record with and timestamps

From: Nilesh Govindarajan
Date: 23 March 2010, 06:42:20
Subject: Re: Replace null values