7.0.2-docs: textpos -> strpos
От | Albert REINER |
---|---|
Тема | 7.0.2-docs: textpos -> strpos |
Дата | |
Msg-id | 20010131161722.A6590@frithjof обсуждение исходный текст |
Ответы |
Re: 7.0.2-docs: textpos -> strpos
|
Список | pgsql-sql |
Saluton, in the 7.0.2-docs I find the function textpos: ,---- | Table 5-5. String Functions | ... | textpos(text,text) text locate specified substring | position('high','ig') `---- However, in psql it seems one has to use strpos: ,---- | litdb=> select textpos('a b', ' '); | ERROR: Function 'textpos(unknown, unknown)' does not exist | Unable to identify a function that satisfies the given argument types | You may need to add explicit typecasts | litdb=> select strpos('a b', ' '); | strpos | -------- | 2 | (1 row) | | litdb=> select version(); | version | -------------------------------------------------------------------- | PostgreSQL 7.0.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1 | (1 row) `---- textpos does not seem to exist: ,---- | litdb=> \df .*pos | List of functions | Result | Function | Arguments | --------+-----------------+------------------------ | int4 | position | text text | float8 | positionjoinsel | oid oid int2 oid int2 | float8 | positionsel | oid oid int2 - int4 | int4 | strpos | text text | (4 rows) `---- Maybe this should be fixed in the docs. Albert. -- -------------------------------------------------------------------------- Albert Reiner <areiner@tph.tuwien.ac.at> Deutsch * English * Esperanto * Latine --------------------------------------------------------------------------
В списке pgsql-sql по дате отправления: