Re: [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!

Gee, I never remember seeing this bug report before.  I have added it to
the TODO list on the WWW page.

> 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...

Thank you.  I have fixed this in the CVS tree.  This fix will be in 6.1
final.


- --
Bruce Momjian
maillist@candle.pha.pa.us

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