This is probably obvious, but I have this in a plpgsql function, where GROUPINGS is a text[]:
SQLSTR := 'SELECT foo,'|| 'bar' = any(GROUPINGS) || ', col2, col3...';
I end up with SQLSTR containin the literal any() statement: SELECT foo, '|| 'bar' = any(GROUPINGS) || ', col2, col3
vs it being coming out like SELECT foo, t, col2, col3.
What am I missing here?