Re: last word in text - Mailing list pgsql-general

From Ian Harding
Subject Re: last word in text
Date
Msg-id se251c6f.086@mail.tpchd.org
Whole thread Raw
In response to last word in text  (Gregory Seidman <gss+pg@cs.brown.edu>)
Responses Re: last word in text
List pgsql-general
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


pgsql-general by date:

Previous
From: Gregory Seidman
Date:
Subject: Re: last word in text
Next
From: dev@archonet.com
Date:
Subject: Re: Wrong query execution.