Expand Vector Arithmetics

Robert, thank you for your idea.

There is a comment on your idea from InterSystems Product Manager. Please answer it to help your idea to be promoted.

Hi Robert, do you have a specific use case in mind for extending the SQL vocabulary here? We don't really see much use for the low-level vector operations in SQL outside of the similarity calculations we're using for Vector Search, other than perhaps a grad school maths homework. Unlike the $vector functions in ObjectScript, everything we'd add to SQL has the potential of colliding with user-defined functions, so we'd like to be cautious and not overload the language with functions no one really needs. And as you have found, it's not hard for those that do need them (for said homework) to implement them as UDFs themselves.

I wrote an overview of what is available actually.
Using VECTORs in ObjectScript
Almost everything is there already. It just needs to be wrapped into SQL Procedures.
Not a big deal for an experienced COS developer

As my replies and comments show it is doable but incredibly uncomfortable
Some simpler approaches as SQL Methods will be attrative

ADD_VECTOR:
>zw vec1,vec2

vec1={"type":"integer", "count":3, "length":3, "vector":[100,300,678]}  ; <VECTOR>

vec2={"type":"integer", "count":3, "length":3, "vector":[123,345,678]}  ; <VECTOR>
>set vplus=$vop("v+",vec1,vec2)

>zw vplus

vplus={"type":"integer", "count":3, "length":3, "vector":[223,645,1356]}  ; <VECTOR>

DIFF_VECTOR:set vdiff=$vop("v-",vec1,vec2)

USER>zw vdiff

vdiff={"type":"integer", "count":3, "length":3, "vector":[-23,-45,0]} ; <VECTOR>

digging across documentation I detected that this is all available in COS!
and even well described in the documentation.

$vector()
$vectorop (ObjectScript)