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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes
"Jonas Forsman" writes:
> sql:
> UPDATE user SET comment= E'[2011-11-16] Note to myself no: 171\\n' ||
> comment WHERE userid=1
> This query fails if comment is an empty string or null.
Define "fails".
Personally I'm wondering whether you remembered that concatenation of a
null with something e
