BUG #1272: text + numeric wrong behaviour
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.
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
first select does not return amount, second does.
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
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
Show quoted text
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, September 29, 2004 5:38 PM
To: Damjan Pipan
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #1272: text + numeric wrong behaviour"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
first select does not return amount, second does.
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