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?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>