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@itech7.com
> <mailto:lists@itech7.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@postgresql.org
>     <mailto:pgsql-general@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-general
>
>

Thanks !

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