Search Postgresql Archives

Re: Replace null values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Nilesh Govindarajan <lists@xxxxxxxxxx>
Subject: Re: Replace null values
From: John R Pierce <pierce@xxxxxxxxxxxx>
Date: Mon, 22 Mar 2010 23:17:15 -0700
Cc: Osvaldo Kussama <osvaldo.kussama@xxxxxxxxx>, pgsql-general General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <4BA84753.5080100@xxxxxxxxxx>
User-agent: Thunderbird 2.0.0.23 (Windows/20090812)

How to convert zero length string to null ?




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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Replace null values
  - From: Nilesh Govindarajan

References:
- Replace null values
  - From: Nilesh Govindarajan
- Re: Replace null values
  - From: Nilesh Govindarajan

Prev by Date: Re: Create a function that updates the record with and timestamps
Next by Date: Re: Replace null values
Previous by thread: Re: Replace null values
Next by thread: Re: Replace null values
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux