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

[Alex Hanshaw]

Hi Roy

Windowing functions in Ingres by release:

Ingres 11.0

  *   LEAD() and LAG()
Ingres 10.2

  *   RANK, DENSE_RANK, PERCENT_RANK, NTILE, and ROW_NUMBER.

If you are using supported functions and getting E_US250F please log an issue.

Thanks

Alex

-------- Original message --------
From: Roy Hann <specially at processed.almost.meat<mailto:specially at processed.almost.meat>>
Date: 3/21/18 05:45 (GMT-08:00)
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: [Info-ingres] Which is the first Ingres release to support window functions?

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

Roy

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>
http://lists.planetingres.org/mailman/listinfo/info-ingres<http://lists.planetingres.org/mailman/listinfo/info-ingres>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180321/6bc1012a/attachment.html>