The following bug has been logged online:

Bug reference: 1272
Logged by: Damjan Pipan

Email address: damjan.pipan (AT) xlab (DOT) 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.




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Huh? I get

regression=# SELECT * FROM a1;
description | amount
-------------+--------
asdasd | 370.00
(1 row)

regression=# SELECT description::varchar, amount FROM a1;
description | amount
-------------+--------
asdasd | 370.00
(1 row)

on both 7.3 and current ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Sorry,

I believe it is bug in pgadmin II.

First you get no amount and when you press refresh on table or query
result is OK.

I found out this 10 min after I have posted bug and did not know where to reply to my bug report.

Damjan




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org