Pierre-Frédéric Caillaud <lists@boutiquenumerique.com> writes:
> One could always use ARRAY[name,name2] > ARRAY['b','a']
> But it is NOT index-friendly...
It won't use an existing two-column index but you can create an expression
index on array[name,name2] and this expression will use it. It won't work if
either column is NULL though.
--
greg