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

From Tom Lane
Subject Re: BUG #1272: text + numeric wrong behaviour
Date
Msg-id 29449.1096472256@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1272: text + numeric wrong behaviour  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1272: text + numeric wrong behaviour
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1273: bad path for english.stop in tsearch2