Phil Endecott wrote:
> !! execute ''column_values :=
> !! column_values || quote_literal(r.'' || cr.column_name || '')'';
I'm guessing you want something like
FOR rec IN EXECUTE ''select column_values || quote_literal(r.'' || cr.column_name ||
'') alias column_values''; LOOP
column_values := rec.column_values;
END LOOP;
another suggestion, rather than do
> if not first then
> column_names := column_names || '', '';
> column_values := column_values || '', '';
> first := false;
> end if;
why not use two arrays and append the name/values using array_append() and use
array_to_string() to join them after that?
--
basic
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
