Re: [GENERAL] array_append not working

2005-04-05 Thread Joe Conway
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 assig

[GENERAL] array_append not working

2005-04-05 Thread Lucas F.
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. Also as a side note is there a straightforward way to get a value from a dynamic query into a local variable? The