Postgres Pro
Downloads
Home   >   mailing lists

Re: PSQL: argument exceeds the maximum length of 1024 bytes - Mailing list pgsql-general

From Pavel Stehule
Subject Re: PSQL: argument exceeds the maximum length of 1024 bytes
Date
Msg-id CAFj8pRD0uYFyndrS7y3jJQyTUTW6JGz_jN5MTmy6MPoaFn644g@mail.gmail.com
Whole thread Raw
In response to Re: PSQL: argument exceeds the maximum length of 1024 bytes  ("Janek Sendrowski" <janek12@web.de>)
List pgsql-general
Tree view

what is in function jaro?

Dne 12. 10. 2013 19:22 "Janek Sendrowski" <janek12@web.de> napsal(a):
I would say it's just a query with to many rows or something like that.
My query was: SELECT jaro('word', col) FROM table.
The tables has ca. 75000 rows. If I'm gonna use the WHERE condition and only select the first 10000 rows, it's working.
So it could be something with the memory, but 1024 bytes?!
 
Janek Sendrowski


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Janek Sendrowski"
Date:
Subject: Re: PSQL: argument exceeds the maximum length of 1024 bytes
Next
From: Pavel Stehule
Date:
Subject: Re: PSQL: argument exceeds the maximum length of 1024 bytes