The following bug has been logged online:
Bug reference: 6295
Logged by: Jonas Forsman
Email address: jfo123(at)hotmail(dot)com
PostgreSQL version: 8.4.9
Operating system: Ubuntu 10.04 LTS
Description: Update fails on empty concatenated strings
Details:
Field description (note the field name is "comment") :
comment character varying(2048)
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.
This works:
UPDATE user SET comment= E'[2011-11-16] Note to myself no: 171\\n' ||
comment || '' WHERE userid=1