[SQL] estrarre solo una parte di un campo in una tabella

[gerwalk]

create table TMP_PG_EXTRACT
as select
data,
qs,
domain,
cname,
from_s,
offset,
substr(NUMBERRESULTS,instr(NUMBERRESULTS,'=',1,1)+ 1,instr(NUMBERRESULTS,',',1,1)-instr(NUMBERRESULTS,'=',1,1)-1) AS PS,
substr(NUMBERRESULTS,instr(NUMBERRESULTS,'=',1,2)+ 1,instr(NUMBERRESULTS,',',1,2)-instr(NUMBERRESULTS,'=',1,2)-1) AS PB,
substr(NUMBERRESULTS,instr(NUMBERRESULTS,'=',1,3)+ 1,instr(NUMBERRESULTS,',',1,3)-instr(NUMBERRESULTS,'=',1,3)-1) AS PU,
substr(NUMBERRESULTS,instr(NUMBERRESULTS,'=',1,4)+ 1,10) AS PM
from TMP_PG_DISP_LOG;

Ciao
Ger