Re: Replace null values

On 03/23/2010 12:17 PM, Sreelatha G wrote:
> Hi,
> select case when name='' then null end from table;
> Thanks
> Sreelatha
> On Tue, Mar 23, 2010 at 12:03 PM, Nilesh Govindarajan <lists(at)itech7(dot)com
> <mailto:lists(at)itech7(dot)com>> wrote:
>
> 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 <http://www.itech7.com/>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

Thanks !

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