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@tpchd.org
(253) 798-3549

>>> Gregory Seidman <gss+pg@cs.brown.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@postgresql.org