Re: BUG #6295: Update fails on empty concatenated strings

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jonas Forsman" <jfo123(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6295: Update fails on empty concatenated strings
Date: 2011-11-16 15:44:38
Message-ID: 23579.1321458278@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> You might possibly want to spell
> the above as SET comment = '...' || coalesce(comment, null) ...

Sheesh. coalesce(comment, '') of course. Need more caffeine.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2011-11-16 19:52:16 Re: Cannot dump 8.4.8 database using later versions
Previous Message Tom Lane 2011-11-16 15:37:33 Re: BUG #6295: Update fails on empty concatenated strings