Re: BUG #1272: text + numeric wrong behaviour

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(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, September 29, 2004 5:38 PM
> To: Damjan Pipan
> Cc: pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] BUG #1272: text + numeric wrong behaviour
>
> "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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
>