That worked - Thanks!
From: Ariel Abadi
Sent: Tuesday, July 9, 11:49 AM
Subject: Re: yum upgrade doesn't allow existing db use new window functions
To: Communication channel for MonetDB users
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
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;
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