on 08-16-2015 12:05 PM
In Oracle it is possible to create User-define aggregate functions.
The MS SQL has the ability to create User-define aggregate functions in the CLR.
Foresees in the future this functionality in the ASE?
would that be useful :
Adaptive Server 15.0.2 introduces user-defined SQL functions.
Use create function to create user-defined functions, and drop function to remove a user-defined function.
You can include these elements in a scalar function:
Adaptive Server does not allow fetch statements in a scalar function that return data to the client. You cannot include :
You can include select or fetch statements that assign values only to local variable.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Very often, I have to analyze the time intervals.
The time intervals are stored as a decimal data type.
The number of 1.55 = 1 hour 55 minutes.
If you are using standard function sum(), these data are summed up correctly (as a decimal).
That is, 1.55 + 0.10 = 1.65, and in decimal notation it is right, but I need the result of 2.05 (2 hours 05 minutes).
Another example is an aggregate function list () (as in the IQ or SqlAnywhere).
These tasks are, of course realizable! However, this requires extra time and effort to implement.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.