function length(numeric) does not exist

Поиск
Список
Период
Сортировка
От Ricardo Sardinha
Тема function length(numeric) does not exist
Дата
Msg-id 000001d0064f$98112d70$c8338850$@sardinha@ti.polynorte.com.br
обсуждение исходный текст
Ответы Re: function length(numeric) does not exist  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-bugs
Version: PostgreSQL 9.2.6, compiled by Visual C++ build 1600, 32-bit

=20

When I try to use the function length occurs the error:

=20

"ERRO: 42883: fun=E7=E3o length(numeric) n=E3o existe" (function =
length(numeric)
does not exist).

=20

Then I try to create length function:

=20

CREATE OR REPLACE FUNCTION length(tsvector)

  RETURNS int4 AS

'$libdir/tsearch2', 'tsvector_length'

  LANGUAGE 'c' IMMUTABLE STRICT;

ALTER FUNCTION length(tsvector) OWNER TO postgres;

=20

But the return is:

=20

-------------------------------------------------------------------------=
---
-------------------------------------------------------------------------=
---
--------

=20

ERRO:  n=E3o p=F4de encontrar fun=E7=E3o "tsvector_length" no arquivo =
"C:/Program
Files/PostgreSQL/9.2/lib/tsearch2.dll"

(could not find function "tsvector_length" in the file "C:/Program
Files/PostgreSQL/9.2/lib/tsearch2.dll")

=20

=20

********** Error **********

=20

ERRO: n=E3o p=F4de encontrar fun=E7=E3o "tsvector_length" no arquivo =
"C:/Program
Files/PostgreSQL/9.2/lib/tsearch2.dll"

(could not find function "tsvector_length" in the file "C:/Program
Files/PostgreSQL/9.2/lib/tsearch2.dll")

=20

SQL state: 42883

=20

-------------------------------------------------------------------------=
---
-------------------------------------------------------------------------=
---
--------

=20

I need the help!

=20

Thanks!

=20

В списке pgsql-bugs по дате отправления:

Предыдущее
От: pmaseberg@accuweather.com
Дата:
Сообщение: BUG #12048: Missing gdal packages for postgresql 9.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12046: lower_inf('(-infinity,today)'::tsrange) returns false