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