select with function per row - Mailing list pgsql-sql

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/