"Jan Peters" <petersjan(at)gmx(dot)at> writes:
> ERROR: operator is not unique: "unknown" || real[]
> EXECUTE 'SELECT id FROM precip_arrays WHERE '||b||' = precip_control;' INTO id_result;
Seems like using EXECUTE is the hardest possible way to do this. Why
don't you just SELECT?
SELECT id FROM precip_arrays WHERE b = precip_control INTO id_result;
If you insist on using EXECUTE then you're going to have to fool with
converting the array to an appropriate text representation.
regards, tom lane