function length(numeric) does not exist

From: "Ricardo Sardinha" <ricardo(dot)sardinha(at)ti(dot)polynorte(dot)com(dot)br>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: function length(numeric) does not exist
Date: 2014-11-22 12:26:48
Message-ID: 000001d0064f$98112d70$c8338850$@sardinha@ti.polynorte.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Version: PostgreSQL 9.2.6, compiled by Visual C++ build 1600, 32-bit

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

"ERRO: 42883: função length(numeric) não existe" (function length(numeric)
does not exist).

Then I try to create length function:

CREATE OR REPLACE FUNCTION length(tsvector)

RETURNS int4 AS

'$libdir/tsearch2', 'tsvector_length'

LANGUAGE 'c' IMMUTABLE STRICT;

ALTER FUNCTION length(tsvector) OWNER TO postgres;

But the return is:

----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------

ERRO: não pôde encontrar função "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")

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

ERRO: não pôde encontrar função "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")

SQL state: 42883

----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------

I need the help!

Thanks!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ludwig.adam 2014-11-23 12:32:28 BUG #12035: Prepared Transactions cannot be ROLLBACKed
Previous Message lizenko79 2014-11-21 15:19:57 BUG #12024: autocomplete doesn't work for ALTER CONSTRAINT