The following psql session terminates with a backend problem. Does
somebody has an idea what went wrong? Can't use `group by' in views,
perhaps?

----------------------------------------------------------------------
=> create table xxx (
date1 date,
date2 date,
id smallint
);
CREATE
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196395 1
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196396 1
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196397 1
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196398 1
=> select date1, date2,
count(id)*(date2-date1) as q
from xxx
group by date1, date2;

date1| date2| q
----------+----------+--
01-01-1999|01-15-1999|56
(1 row)

=> create view xxx1 as
select date1, date2,
count(id)*(date2-date1) as q
from xxx
group by date1, date2;
CREATE
=> select * from xxx1;

PQexec() -- Request was sent to backend, but backend closed the
channel before responding. This probably means the backend
terminated abnormally before or while processing the
request.
----------------------------------------------------------------------

I'm still using version 6.3.2

Many thanks,
Ulf

--
======================================================================
%%%%% Ulf Mehlig <ulf(dot)mehlig(at)uni-bremen(dot)de>
%%%%!%%% Projekt "MADAM" <umehlig(at)uni-bremen(dot)de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~