Функцией добавить колонку в представление

CREATE FUNCTION get_entity_status(in_entity_type text, in_entity_id INTEGER) RETURNS text
LANGUAGE plpgsql
AS $$
DECLARE
  var_status_name text;
BEGIN
  var_status_name := '';
 
  IF in_entity_type ilike 'USER' THEN
 
    WITH countdown_timestamp AS (
        SELECT ((now()) :: DATE - ((settings_global.metric_days) :: DOUBLE PRECISION * '1 day' :: INTERVAL)) AS from_date
        FROM settings_global
        ORDER BY settings_global.id
        LIMIT 1
    ), user_status AS (
        SELECT
          us.id,
          CASE
          WHEN st.id = 1 AND us.date_updated < ct.from_date
            THEN arch_st.name
          WHEN st.id = 1 AND us.date_updated >= ct.from_date
            THEN act_st.name
          ELSE st.name
          END AS status_name
        FROM "user" us
          JOIN STATUS st ON (us.status_id = st.id)
          CROSS JOIN countdown_timestamp ct
          JOIN STATUS arch_st ON (arch_st.id = 4)
          JOIN STATUS act_st ON (act_st.id = 2)
        WHERE us.id = in_entity_id
    )
    SELECT COALESCE((SELECT status_name FROM user_status), '') INTO var_status_name;
 
  ELSIF in_entity_type ilike 'CLIENT' THEN
 
    WITH countdown_timestamp AS (
        SELECT ((now()) :: DATE - ((settings_global.metric_days) :: DOUBLE PRECISION * '1 day' :: INTERVAL)) AS from_date
        FROM settings_global
        ORDER BY settings_global.id
        LIMIT 1
    ), client_status AS (
        SELECT
          cl.id,
          CASE
          WHEN st.id = 1 AND cl.date_updated < ct.from_date
            THEN arch_st.name
          WHEN st.id = 1 AND cl.date_updated >= ct.from_date
            THEN act_st.name
          ELSE st.name
          END AS status_name
        FROM client cl
          JOIN STATUS st ON (cl.status_id = st.id)
          CROSS JOIN countdown_timestamp ct
          JOIN STATUS arch_st ON (arch_st.id = 4)
          JOIN STATUS act_st ON (act_st.id = 2)
        WHERE cl.id = in_entity_id
    )
    SELECT COALESCE((SELECT status_name FROM client_status), '') INTO var_status_name;
 
  END IF;
 
  RETURN var_status_name;
END
$$;

-- View: public.v_all_clients
 
-- DROP VIEW public.v_all_clients;
 
CREATE OR REPLACE VIEW public.v_all_clients AS 
 WITH countdown_timestamp AS (
         SELECT now()::DATE - settings_global.metric_days::DOUBLE PRECISION * '1 day'::INTERVAL AS from_date
           FROM settings_global
          ORDER BY settings_global.id
         LIMIT 1
        ), terminal_usage_info AS (
         SELECT DISTINCT u.terminal_server_id AS client_id
           FROM usage u
             CROSS JOIN countdown_timestamp ct
             JOIN usage_concurrent uc_1 ON u.id = uc_1.usage_id AND uc_1.date > ct.from_date
             JOIN client cl_1 ON u.terminal_server_id = cl_1.id
        )
 SELECT cl.id AS client_id,
    cl.automatic_org,
    cl.purchase_date,
    cl.is_sub_capacity_eligible,
    cl.is_device,
    cl.is_spla_server,
    cl.pvu,
    cl.notes,
    cl.manufacturer,
    cl.is_terminal_server,
    cl.purchase_price,
    cl.date_added,
    cl.is_portable,
    cl.is_server,
    cl.is_virtual,
    cl.computer_model,
    cl.status_id,
    cl.sku,
    cl.system_type,
    cl.total_number_of_processors,
    cl.total_number_of_processor_cores,
    cl.total_cpu_sockets,
    cl.total_memory_slots,
    cl.empty_memory_slots,
    cl.computer_name,
    cl.organization_id,
    cl.hypervisor_name,
    cl.owner_name,
    cl.identifying_number,
    cl.uuid,
    cl.thermal_state,
    cl.is_part_of_domain,
    cl.domain_id,
    cl.workgroup_id,
    cl.time_zone,
    cl.date_updated,
    org.name AS org_name,
    MIN(net.ip_address::text)::CHARACTER VARYING AS ip_address,
    dom.name AS domain_name,
    os.name AS os_name,
    cl.exclude_all_installations,
        CASE
            WHEN tui.client_id IS NOT NULL THEN TRUE
            ELSE FALSE
        END AS has_devices,
    cl.has_agent,
    cl.is_host
   FROM client cl
     LEFT JOIN organization org ON org.id = cl.organization_id
     LEFT JOIN DOMAIN dom ON dom.id = cl.domain_id
     LEFT JOIN x_client_network_adapter net ON net.client_id = cl.id AND net.default_gateway::text <> ''::text
     LEFT JOIN x_client_os cos ON cos.client_id = cl.id
     LEFT JOIN os ON os.id = cos.os_id
     LEFT JOIN terminal_usage_info tui ON cl.id = tui.client_id
  WHERE cl.id IS NOT NULL
  GROUP BY cl.id, cl.automatic_org, cl.purchase_date, cl.is_sub_capacity_eligible, cl.is_device, cl.is_spla_server, cl.pvu, cl.notes, cl.manufacturer, cl.is_terminal_server, cl.purchase_price, cl.date_added, cl.is_portable, cl.is_server, cl.is_virtual, cl.computer_model, cl.status_id, cl.sku, cl.system_type, cl.total_number_of_processors, cl.total_number_of_processor_cores, cl.total_cpu_sockets, cl.total_memory_slots, cl.empty_memory_slots, cl.computer_name, cl.organization_id, cl.hypervisor_name, cl.owner_name, cl.identifying_number, cl.uuid, cl.thermal_state, cl.is_part_of_domain, cl.domain_id, cl.workgroup_id, cl.time_zone, cl.date_updated, org.name, dom.name, os.name, tui.client_id;
 
ALTER TABLE public.v_all_clients
  OWNER TO ilgiz;