Postgres Pro
Downloads
Home   >   mailing lists

Re: Replace null values - Mailing list pgsql-general

From Nilesh Govindarajan
Subject Re: Replace null values
Date
Msg-id 4BA860D7.5020105@itech7.com
Whole thread Raw
In response to Re: Replace null values  (John R Pierce <pierce@hogranch.com>)
Responses Re: Replace null values  (Ian Haywood <ihaywood@iinet.net.au>)
List pgsql-general
Tree view 
On 03/23/2010 11:47 AM, John R Pierce wrote:
>
>> How to convert zero length string to null ?
>
>
>
> UPDATE yourtable SET name=NULL WHERE name='';
>
>

No I don't want to replace it in the table. Just in the query result.

--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Replace null values
Next
From: Nilesh Govindarajan
Date:
Subject: Re: Replace null values