Re: last word in text

I am certain it can, but you could make pltcl available (if you have the rights) by typing

createlang 'pltcl' yourdatabasename

at the command prompt.

Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
iharding(at)tpchd(dot)org
(253) 798-3549

>>> Gregory Seidman <gss+pg(at)cs(dot)brown(dot)edu> 01/15/03 08:13AM >>>
Ian Harding sez:
} create function lastword(varchar) returns varchar as '
} return [string range $1 [string last " " $1] end]
} ' language 'pltcl';

I don't seem to have pltcl available. In fact, all I have available is
plpgsql and sql. Can it be done in either of those languages?

} Ian Harding
--Greg

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org