function length(numeric) does not exist - Mailing list pgsql-bugs

From Ricardo Sardinha
Subject function length(numeric) does not exist
Date
Msg-id 000001d0064f$98112d70$c8338850$@sardinha@ti.polynorte.com.br
Whole thread Raw
Responses Re: function length(numeric) does not exist  (David G Johnston <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: pmaseberg@accuweather.com
Date:
Subject: BUG #12048: Missing gdal packages for postgresql 9.4
Next
From: Tom Lane
Date:
Subject: Re: BUG #12046: lower_inf('(-infinity,today)'::tsrange) returns false