471,073 Members | 1,449 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

User-defined aggregate functions and OLAP windowing

Friends:

In v8 or v9 LUW, if I were to write (in Java or C) my own user-defined
aggregate function, would I be able to use it in an OLAP windowing
clause as I could use, e.g., COUNT or SUM?

Example:

SELECT
JEFFS_UDAF() OVER(PARTITION BY SOME_COL)
FROM
SOME_TABLE;

--Jeff
Jul 9 '08 #1
0 1841

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

60 posts views Thread by Fotios | last post: by
3 posts views Thread by zlst | last post: by
6 posts views Thread by martin | last post: by
2 posts views Thread by rn5a | last post: by
1 post views Thread by Carlettus | last post: by
3 posts views Thread by shapper | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.