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:[EMAIL PROTECTED] > Sent: Wednesday, September 29, 2004 5:38 PM > To: Damjan Pipan > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] BUG #1272: text + numeric wrong behaviour > > "PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
