Mike Plemmons wrote:
I am trying to run this function but the return is not correct.
PS - next time, details of what it *did* return and why that wasn't correct would be useful. Not needed in this case, but good practice anyway.
PPS - the subject line was pretty good, but better might have been "Problem with LIKE and variables in a plpgsql function"
PPPS - This is a fairly inefficient way of running simple queries. PPPPS - Thanks for the question! -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend