String function page incorrect?
От | Jonathan Ellis |
---|---|
Тема | String function page incorrect? |
Дата | |
Msg-id | 017c01c05b05$5729dfa0$0d00a8c0@dsl.inconnect.com обсуждение исходный текст |
Ответы |
Re: String function page incorrect?
|
Список | pgsql-sql |
I'm trying to find the correct function that returns the location of a substring within a string. Looking at http://www.postgresql.org/docs/user/x2731.htm, it gives the Function name as "textpos" but in the Example column it uses "position". But neither one works! bf2=# select position('high', 'ig'); ERROR: parser: parse error at or near "," bf2=# select textpos('high', 'ig'); ERROR: Function 'textpos(unknown, unknown)' does not existUnable to identify a function that satisfies the given argumenttypesYou may need to add explicit typecasts bf2=# select textpos(text('high'), text('ig')); ERROR: Function 'textpos(text, text)' does not existUnable to identify a function that satisfies the given argument typesYoumay need to add explicit typecasts ??? -Jonathan
В списке pgsql-sql по дате отправления: