Re: last word in text

Поиск
Список
Период
Сортировка
От Ian Harding
Тема Re: last word in text
Дата
Msg-id se251c6f.086@mail.tpchd.org
обсуждение исходный текст
Ответ на last word in text  (Gregory Seidman <gss+pg@cs.brown.edu>)
Ответы Re: last word in text  (Gregory Seidman <gss+pg@cs.brown.edu>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Seidman
Дата:
Сообщение: Re: last word in text
Следующее
От: dev@archonet.com
Дата:
Сообщение: Re: Wrong query execution.