KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ select avg (ignore null) Re: select avg (ignore null)

  • davidcrossey

    Member
    June 30, 2022 at 12:00 am

    avg/min/max/sum where implemented similar to SQL92 as per the note here.

    From what I gather, there are some optimizations available for a vector that aren’t available for a slice, hence the functionality we see today, and trying to change this would be difficult now as you might, (and probably will) see different results in an existing system.