Thread: BUG #1272: text + numeric wrong behaviour

The following bug has been logged online:

Bug reference:      1272
Logged by:          Damjan Pipan

Email address:      damjan.pipan@xlab.si

PostgreSQL version: 7.3.2

Operating system:   linux 2.4

Description:        text + numeric wrong behaviour

Details:

CREATE TABLE a1(
  description text,
  amount numeric(9,2)
);

INSERT INTO a1 VALUES ('asdasd', 370);
SELECT * FROM a1;

SELECT description::varchar, amount FROM a1;

first select does not return amount, second does.

"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

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
>