Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6295: Update fails on empty concatenated strings - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6295: Update fails on empty concatenated strings
Date
Msg-id 23579.1321458278@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6295: Update fails on empty concatenated strings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6295: Update fails on empty concatenated strings
Next
From: Josh Berkus
Date:
Subject: Re: Cannot dump 8.4.8 database using later versions