The following bug has been logged online: Bug reference: 6295 Logged by: Jonas Forsman Email address: jfo...@hotmail.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs