CREATE OR REPLACE FUNCTION get_asset_ids( _ent...
# umh-support
j
CREATE OR REPLACE FUNCTION get_asset_ids( _enterprise text, _site text DEFAULT '', _area text DEFAULT '', _line text DEFAULT '', _workcell text DEFAULT '', _origin_id text DEFAULT '' ) RETURNS SETOF integer AS ' BEGIN RETURN QUERY SELECT id FROM asset WHERE enterprise = _enterprise AND (_site = '''' OR site = _site) AND (_area = '''' OR area = _area) AND (_line = '''' OR line = _line) AND (_workcell = '''' OR workcell = _workcell) AND (_origin_id = '''' OR origin_id = _origin_id); END; ' LANGUAGE plpgsql; Kafka-to-postgres neustarten sudo $(which kubectl) rollout restart deployment united-manufacturing-hub-kafkatopostgresqlv2 -n united-manufacturing-hub --kubeconfig /etc/rancher/k3s/k3s.yaml
2 Views