BUG #13429: Update 0 rows for matching record

The following bug has been logged on the website:

Bug reference: 13429
Logged by: Sandeep Moola
Email address: smoola(at)travelclick(dot)com
PostgreSQL version: 9.2.8
Operating system: Red Hat Enterprise Linux Server release 6.5
Description:

We were trying to update a record in our database as below and the row was
not getting updated. No error was shown neither on the command promt nor in
the logs
STEP1:
SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
yrd_yrd_key=10060451491;
yrd_cuttoff
-------------
N
(1 row)

STEP2:
UPDATE yrd_yield_room_details SET yrd_cuttoff='NC' WHERE
yrd_yrd_key=10060451491;
UPDATE 0

STEP3:
SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
yrd_yrd_key=10060451491;
yrd_cuttoff
-------------
N