>>>> "Thomas" == Thomas G Lockhart <lockhart@alumni.caltech.edu> writes:
>> I'm trying postgres 6.4.1 and I have problem with select command: >> > create table t( text_column text ); >>
>select sum( text_column ) from t; >> This command makes no sense, but causes crash in backend:
Thomas> Thanks for finding this. It was in new code for automatic type matching Thomas> and coersion on aggregate
functionsto help implement aggregates for the Thomas> string types.
Thomas> I've enclosed a simple patch which fixes the problem, and which at the Thomas> same time makes a nicer
warningmessage as a result:
Thomas> postgres=> select sum(c) from cc; Thomas> ERROR: Unable to select an aggregate function sum(bpchar)
Thomas>postgres=> select min(c) from cc; Thomas> min Thomas> ---------- Thomas> abc Thomas> (1 row)
Thomas> Will commit to the cvs tree sometime soon; let me know if you have any Thomas> continuing problems. Good
luck.
Thanks, works fine. Happy Xmas, David
--
* David Sauer, student of Czech Technical University
* electronic mail: davids@iol.cz (mime compatible)