Hi,
I have a table with FQDN. I'm trying to take from it the second part which
desribed a city. Query isn't too clear but with what is important that
whole substr was counted once and applied to every row. Can I (how?) force
executor to run this substr on every row of my table?
mtldb=# select substr(substr(s.nazwa,strpos(s.nazwa,'a.')+2),1, textlen(s.nazwa)-strpos(s.nazwa,+'.m'))
from serwery_old s;substr
--------poznanmtl.plka.kie
tia
maz
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/