Lucas F. wrote:
> 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