[Info-ingres] FW: Which is the first Ingres release to support window functions?

Roy Hann specially at processed.almost.meat
Wed Mar 21 14:42:40 UTC 2018


Alex Hanshaw wrote:

> Windowing functions in Ingres by release:
>
> Ingres 11.0
>
>   *   LEAD() and LAG()
> Ingres 10.2
>
>   *   RANK, DENSE_RANK, PERCENT_RANK, NTILE, and ROW_NUMBER.

Ah. That answers it Alex. I was trying to use lag() in 10.2. The error
message mislead me by complaining about OVER.

Thanks Alex.

Roy



More information about the Info-ingres mailing list