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