BUG #1272: text + numeric wrong behaviour - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1272
Logged by:          Damjan Pipan

Email address:      damjan.pipan@xlab.si

PostgreSQL version: 7.3.2

Operating system:   linux 2.4

Description:        text + numeric wrong behaviour

Details:

CREATE TABLE a1(
  description text,
  amount numeric(9,2)
);

INSERT INTO a1 VALUES ('asdasd', 370);
SELECT * FROM a1;

SELECT description::varchar, amount FROM a1;

first select does not return amount, second does.