Array operators

[mwpowellhtx]

So interesting are these HQL functions are you registering

// array_contains(arr, 3) => :num = any(arr)
RegisterFunction("array_contains", new SQLFunctionTemplate(NHibernateUtil.Boolean, "?2 = any(?1)"));

// array_intersects => ?1 && ?2
RegisterFunction("array_intersects", new SQLFunctionTemplate(NHibernateUtil.Boolean, "?1 && ?2"));

Any thoughts on something like array_length, is it necessary? How about array_except, I'm not sure what the operator would be for that, i.e. "?1 ^ ?2". Or does it assume known SQL or HQL operators in order for the registered functions to work?

[beginor]

Please read this article https://beginor.github.io/2024/09/16/add-support-of-postgresql-array-type-for-nhibernate.html , it's writen in chinese, but I think you can read it by a translation tool.

[mwpowellhtx]

Fundamentally it makes sense. When you say Use SQL to query and filter, filter is at the HQL level, correct? What of the HQL operators however; intersects i.e. "?1 && ?2". I am not sure for except(...) would something like "?1 ^^ ?2" be possible. Assuming there is an exclusion operator, or perhaps modulo, "?1 %% ?2". Failing that, except(?1, ?2).