E id =
enc_row.dx12;
dx_list := array_append(dx_list, current_dx_str);
END IF;
IF loop_counter = 1
THEN
primary_dx := current_dx_str;
END IF;
END LOOP;
RETURN QUERY SELECT array_to_string(dx_list, ','),
primary_dx;
END;
$$ LANGUAGE plpgsql;
create materialized view vtest as
SELECT chg.id
Hi,
I'm currently testing an application with Postgres 17.2 and am getting an
error when creating a materialized view which works in version 16 and
below. The sql works fine running as a query, but adding the
create materialized view breaks it.
The error comes when calling a custom function and t
