BUG #1272: text + numeric wrong behaviour

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1272: text + numeric wrong behaviour
Date: 2004-09-29 09:46:40
Message-ID: 20040929094640.2C1805A1061@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1272
Logged by: Damjan Pipan

Email address: damjan(dot)pipan(at)xlab(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2004-09-29 10:13:49 Re: BUG #1271: Installation problems (cannot execute initdb.exe)
Previous Message PostgreSQL Bugs List 2004-09-29 09:39:53 BUG #1271: Installation problems (cannot execute initdb.exe)