Hi,
What does it mean if the Error: 'argument exceeds the maximum length of 1024 bytes' is raising using psql.
How can I increase this limit?
Janek Sendrowski
Now the Steps:
$ USE_PGXS=1 make
$ USE_PGXS=1 make install
are working.
But I still don't have the directory 'SHAREDIR/contrib/pg_similarity.sql'
Janek Sendrowski
Thanks a lot!
Now it's working :)
Janek Sendrowksi
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Now the Steps:
$ USE_PGXS=1 make
$ USE_PGXS=1 make install
are working.
But I still don't have the directory 'SHAREDIR/contrib/pg_similarity.sql'
Janek Sendrowski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
Hi,
I have some problems to install the pg_similarity Module. It's my first time to install something like that and I'm a novice in Linux.
This is the Introduction:
tar -zxf pg_similarity-0.0.19.tgz
$ cd pg_similarity-0.0.19
$ $EDITOR Makefile # edit PG_CONFIG iif necessary
$ USE_PGXS=1 make
$
Hi,
I found following code:
create or replace function plpgsql_edit_distance(stra text, strb text)
returns integer as $$
declare
rows integer;
cols integer;
begin
rows := length(stra);
cols := length(strb);
IF rows = 0 THEN
return cols;
END IF;
IF co
Hi,
this is my query:
SELECT user,
sum(CASE WHEN lev >= 50 AND lev < 70 THEN 1 ELSE 0 END) as a,
sum(CASE WHEN lev >= 70 AND lev < 80 THEN 1 ELSE 0 END) as b,
sum(CASE WHEN lev >= 80 AND lev <= 90 THEN 1 ELSE 0 END) as c,
sum(CASE WHEN lev > 90 THEN 1 ELSE 0
Where can I change levensthein_max_length?
Janek Sendrowski
Von: "Szymon Guz"
An: "Tom Lane"
Betreff: Re: [GENERAL] Levenshtein Distance with more than 255 characters
On 6 September 2013 08:47, Tom Lane wrote:
> Szymon Guz writes:
> > On 6 September 2013 01:00, Janek Sendrowski wrote:
> >> I
