WITH
cte AS (
SELECT name,
STRPOS(name, ' ') leftpos,
STRPOS(REVERSE(name), ' ') rightpos
FROM outcomes
),
cte2 AS (
SELECT name,
CASE WHEN leftpos = 0 THEN name ELSE LEFT(name, leftpos) END first,
CASE WHEN rightpos = 0 THEN name ELSE RIGHT(name, rightpos) END last
FROM cte
),
cte3 AS (
SELECT name, first, last,
LENGTH(name) - LENGTH(first) - LENGTH(last) - 2 middlelen
FROM cte2
)
SELECT name,
first || ' ' || REPEAT('*', middlelen) || ' ' || last starname
FROM cte3
WHERE middlelen > 0smartctl -a /dev/sda -d megaraid,1 или smartctl -a /dev/sda -d sat+megaraid,1 Возможно, придётся поиграть числом после запятой. У меня, например, это номера с 12 по 19.
/dev/bus/0 -d megaraid,12 # /dev/bus/0 [megaraid_disk_12], SCSI device