[HACKERS] Re: [QUESTIONS] BUG: aggregate functions and @ operator.

I was cleaning out old mail and found this posting, which I started
looking into. Looks like a parser problem, or something in that area,
rather than a data type problem. Still present in v6.1. Bruce or Vadim
or ??, do you have any ideas on this?

>> I think I found a bug in PostgreSQL v6.0. Whenever I try to use an
>> aggregate function (tested with sum, avg and min) whith an absolute value
>> (@ operator) in the formula, the backend crashes.

Here is a test case:
create table test ( a float4);
insert into test values ( 2 );
select @(a) from test;         (OK)
select sum(a) from test;       (OK)
select sum(@a) from test;      (Backend crash)

But, even an "explain" crashes the backend!

tgl=>  explain verbose select sum(@a) from test\g
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.

btw, "\h explain" is out of date. I *think* that the new syntax is
"explain [verbose] ..." and will update the help file if you would like
me to...

All testing was on a 970610 snapshot.

            - Tom

------------------------------