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
> -----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
>