On Tue, Mar 23, 2010 at 5:33 PM, Nilesh Govindarajan <lists@xxxxxxxxxx> 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. use a CASE construct. select case name='' then null else name end from table where ...... Ian -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
