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