From: | Michael Contzen <mcontzen(at)dohle(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Numeric and Aggregate: transform node 107 |
Date: | 1999-05-21 12:45:43 |
Message-ID: | 01bea387$d6e1d770$4dbe7fc2@wcontzen.dohle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hallo,
first of all, thank you for fixing the ´hash table overflow problem´, I´ve tested it on a join between a 2GB and a 3MB table, it works!
Now, I tried to use the numeric type, and hit the following problem:
create table a (val numeric(10,2));
CREATE
insert into a values('123.45');
INSERT 2402633 1
create table b (val numeric(10,2));
CREATE
insert into b select sum(val) into b;
ERROR: transformExpr: does not know how to transform node 107
insert into b select float8(sum(val)) into b;
INSERT 2402643 1
One other (SQL-) question: How can I cast results to numeric directly? Using float8 cast and the following implicit cast is not very nice.
Kind regards,
Michael Contzen
Dohle Systemberatung, Germany
Email: mcontzen(at)dohle(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Samersoff | 1999-05-21 12:55:57 | RE: [HACKERS] web site addition |
Previous Message | Vadim Mikheev | 1999-05-21 11:20:03 | Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction |