Sorry, this is probably a dumb mistake on my part. New to Postgres. Running 8.0 on Linux.
The array_append below is giving me a syntax error, and I have no idea what I am doing wrong.
array_append(v_query_array,(rec.item_field_name || '=' || v_value::text)::text);
You need to assign the result of array_append() to a variable. It doesn't change v_query_array in place.
Joe
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly