feat: support array containment @>, <@

[thexiay]

Is your feature request related to a problem? Please describe.

This is a subfunction of #7117

This is appropriate as my good first issue

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[thexiay]

Infact pgsql has type range but risingwave does not have type defined range , but this operator usage like this:

Is there necessary to add array contains element ? I try it in pgsql and it;s not ok:

Or Just Keep the behavior consistent with pgsql？
cc @wangrunji0408 @st1page @lmatz

[wangrunji0408]

Hi. We'll keep consistent with pg and we are going to add array @> array soon. This should be able to support array containment. There will be no array contains element operation for this.

[thexiay]

Hi. We'll keep consistent with pg and we are going to add array @> array soon. This should be able to support array containment. There will be no array contains element operation for this.

I have done this issue and I will request a mr as soon as possible.

[stdrc]

Closed by #13253