The following bug has been logged online:
Bug reference: 1272
Logged by: Damjan Pipan
Email address: [EMAIL PROTECTED]
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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
