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

[Karl and Betty Schendel]

On Mar 21, 2018, at 8:43 AM, Roy Hann <specially at processed.almost.meat> wrote:
> 
> Window functions are documented in the Ingres 10.2 SQL Guide.
> 
> Attempting to do even trivial queries in II 10.2.0 (su9.us5/100) I am
> getting "E_US250F SELECT: OVER clause only supported on Vectorwise
> tables".

I tried (in iidbdb):
select name, own, rank() over (order by name)
from iidatabase order by own

and it worked for me.

Karl