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!
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 |