[HACKERS] Re: ToDo list

>
> I was looking through the ToDo list on the web page and would suggest
> removing the item concerning the SUM aggregate in RELIABILITY:
>
> RELIABILITY
> -----------
> ...
> -SUM aggregate on no rows or null value should return NULL, not
> zero(Thomas)

Read the top of the file.  The dash means it is being worked on for 6.1.

> ...
>
> And modifying the item concerning SUM() in v6.1 Bug Fixes:
>
> Bug Fixes
> ---------
> ...
> select SUM(x) and AVG(x) on NULL or zero rows returns NULL (Thomas)
> ...
>
> Additional things to add for future enhancements:
>
> There is currently a problem using count(*) in table joins (the parser
> tries to choose the OID column and complains that there is more than one
> column by that name).

We already have:

    SELECT COUNT(*) FROM TAB1, TAB2 fails

>
> Also, we currently do not do implicit type conversions for column
> inserts or updates from other columns or tables.

We also have:

    Allow INSERT INTO ... SELECT to convert column types


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

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