BUG #6529: Invalid numeric input syntax for 'select into' queries

The following bug has been logged on the website:

Bug reference:      6529
Logged by:          Maxim Turchin
Email address:      nehxby@gmail.com
PostgreSQL version: 9.1.3
Operating system:   Ubuntu 11.10
Description:=20=20=20=20=20=20=20=20

CREATE TYPE test_bug_type AS
    (value numeric(15,2),
    currency_id varchar);

CREATE TABLE test_bug_table (
    id serial PRIMARY KEY,
    test_field test_bug_type
);

INSERT INTO test_bug_table (test_field) VALUES ('(15.50,USD)');

DO
$$DECLARE
    test_bug_var test_bug_type;
BEGIN
    SELECT test_field INTO test_bug_var FROM test_bug_table LIMIT 1;
--ERROR:  invalid input syntax for type numeric: "(15.50,USD)"
--CONTEXT:  PL/pgSQL function "inline_code_block" line 7 at SQL statement

    -- OR:
    INSERT INTO test_bug_table (test_field) VALUES ('(35.80,EUR)')
    RETURNING test_field INTO test_bug_var;
--ERROR:  invalid input syntax for type numeric: "(35.80,EUR)"

    RAISE NOTICE 'Test %', test_bug_var;
END;$$;

DROP TABLE test_bug_table;
DROP TYPE test_bug_type;