Hi!

I dont know why, but sometimes you need to the prefix sys. to the function to make it happend.

Try the following:

select sys.first_value(col1) over (partition by col2) from analytics;

Rgds

Ariel

On Tue, Jul 9, 2019 at 1:44 PM Andy Allaway <heyitsmeandy@outlook.com> wrote:

Hi,

I ran:

yum upgrade MonetDB-SQL-server5 MonetDB-client

When I create a new db I can call:

select first_value(col1) over (partition by col2) from analytics;

as per the blog monetdb.org/blog/extended_sql_window_functions

However a db that existed before the update returns:

Function first_value not found.

I can see first_value in sys.functions.

Any suggestions?

Thanks!

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list