Thanks!
It's working
Janek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I want to delete duplicates in my table. I've dropped the unique constraint to
insert my data.
My id value is a hash calculated witch the values of the two other columns.
So I want to delete all columns, which are indentical, but keeping one.
DELETE FROM table t1 USING table t2 WHERE t1.id
Thanks!
That's what I'm searching for.
Janek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
How can I realize the line?
v_res := cast(x'v_tmp' as bigint);
v_tmp is a text variable with hex digits.
this works:
v_res := cast(x'6de14a8b478ac' as bigint);
I think its about quoting
Janek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
Hi Salah Jubeh,
I'm not in hurry ;)
Thanks for your answer. Thats what I've been searching for.
Janek Sendrwoski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Salah Jubeh,
My files don't have this format. Could it make sense to create such a file with
php and import the data from it?
Or ist also possible the get certain rows from the file with regexp?
Janek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
Hi,
I want to insert data in my table and I want to insert the rows, which don't
violates the unique contraint of my id. I'm using a 64bit hash for my it.
If I do one insert statement, which inserts many rows it doesn't do anything if
one row violates the unique contraint.
Is there a faster way
Sorry, I used AND-statements instead of OR-statement in the example.
I notices that gin is much faster than gist, but I don't know why.
The query gets slow, because there are many non-stop words which appear very
often in my sentences, like in 3% of all the sentences.
Do you think it could be wor
h':19
(1 row)
SELECT * FROM tablename WHERE vector @@ to_tsquery('speci & tiger & total &
weigh') AND vector @@ to_tsquery('largest & length & m & reach') AND vector @@
to_tsquery('3.3 & 306 & bodi & cat & kg');
An
Array), but it's all to slow or not suitable.
Soundex and Metaphone aren't suitable, as well.
I'm already working on this project since a long time, but without any success.
Do any of you have an idea?
I would be very thankful for help.
Janek Sendrowski
--
Sent via pgsql-general
of hashvalue for each row to filter the
rows dirty at first.
Thank you for your help
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
Hi,
Is there a documentation of postgresql's C functions like SET_VARSIZE for
exmaple?
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
Hi,
How is it possible to debug user defined functions written in C.
I can't just include all the files and run it.
Does anyone have an idea?
Janek Sendrowski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
st do "gcc filename", I
have the issue with the includes.
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
vel-packages.
Could I just reinstall the postgresql-server-dev-9.3 package?
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
;s the same with all directories...
Sorry, if this question is to silly, but what do I wrong?
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
ot find -lxslt
/usr/bin/ld: cannot find -lxml2
/usr/bin/ld: cannot find -lpam
/usr/bin/ld: cannot find -ledit
collect2: ld returned 1 exit status
make: *** [test] Error 1
Does anyone have an idea?
Janek Sendrowski
in/ld: cannot find -lxslt
/usr/bin/ld: cannot find -lxml2
/usr/bin/ld: cannot find -lpam
/usr/bin/ld: cannot find -ledit
collect2: ld returned 1 exit status
make: *** [test] Error 1
Does anyone have an idea?
Janek Sendrowski
n the files for first.
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
Thanks for your help!
I updated to version 9.3 and now it's working.
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
Hi,
My current version is 9.2. I could just update it.
I got the pg_trgm from here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/pg_trgm;hb=refs/heads/master
And the regex files from here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/include/reg
ope there is someone who can help me
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
Thanks a lot for your Answers.
That's what I was looking for.
I couln't find it.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I like to change the source code of the pg_trgm extension a little bit.
Where can I get the source code and how do I compile it?
I can only find the SQL-files of pg_trgm in my directories.
Janek Sendowksi
Hi Amit,
Do you think it would by difficult to edit the source and wirte a new function,
wich does it?
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
I still need a ranking...
something like SELECT similarity('How are your', "{" ho","how","are","re ","
hi","wha","hat","at "," a"}"::trgm);
I hope you have an idea
Janek Sendrowski
or maybe with putting
the string in brackets or quoting?
Or do I have to change the source code?
Thanks for your help
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
Thanks for your Answers!
@Martijn van Oosterhout
I am always searching for single colums. The values are different every time,
because these are distances from my new sentence to my pivots.
Does the Index support a query with this WHERE statement: WHERE value BETWEEN
(distance1 - radius) AND
ance4 + radius)
...
Now I'm searching for a suitable index.
Does any of you have an idea?
TX very much for any support!
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
Hi,
I am trying to build my database with a metric index. I am using a Fixed Query
Array.
I have got a table with many sentences of natural languages. I'm using the Dice
Coefficient for calculating the metric space.
I am going to take a certain number of sentences and use them as pivots by
calc
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
Do you know the destination. I cant find it.
Hi,
I'm searching for an optimized Levenshtein Distance like Postgresql's. My problem is that I want to compare strings with a length over 255 characters.
Does anyone know a solution?
Janek Sendrowski
The links don't work.
I don't know why.
how just don't know how to insert the data of a record in a table
the record into the temp table?
Janek Sendrowski
Hi,
Why is it only possible to store one row by a query which returns multiple rows using the SELECT INTO statement.
and
How can I do a Query on a record varialbe, somehow like this:
SELECT * FROM v_rec
Janek Sendrowski
de which range the endpoint includes.
Janek Sendrowski
Sorry, I formulated it wrong.
My problem is, that I want to count the ranges for every user, but if I use count(range), it counts the ranges of all users.
Janek Sendrowski
w how to do that
A result should look like this:
user percentagecount
smith "0 to 25" 5
smith "25 to 50"7
smith "50 to 75"2
jones "0 to 25" 11
jones "25 to 50"1
jones "50 to 75"3
Hope so
Hi,
I have an array and I want to import the data rowwise.
Would it make sense to use a function which calls a prepared statement in a
loop to import the data performant?
Or can I somehow use the COPY FROM command?
Janek Sendrowski
--
Sent via pgsql-general mailing list (pgsql-general
just to do one query at once?
Hope someone can help me.
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
m 00:24 Uhr
Von: bricklen
An: "Janek Sendrowski"
Cc: "pgsql-general@postgresql.org"
Betreff: Re: [GENERAL] devide and summarize sql result (all)
On Thu, Aug 15, 2013 at 1:51 PM, Janek Sendrowski <jane...@web.de> wrote:
Hi,
My sql query results sth. like t
Hi,
My sql query results sth. like this:
user percentage
franz 78%
smith 98%
franz 81%
jason 79%
smith 89%
smith 85%
smith 99%
Now I'd like to summarize the percentages oder every user like this.
smith
2 matches 95-100%
2 matches 85-95%
0 mathes 75-85%
franz
0 mathes 95-100%
..
Hi,
My sql query results sth. like this:
user percentage
franz 78%
smith 98%
franz 81%
jason
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Sergey Konoplev,
If I'm searching for a sentence like "The tiger is the largest cat species" for
example.
I can only find the sentences, which include the words "tiger, largest, cat,
species", but I also like to have the sentences with only three or even two of
these words.
Janek
--
Thanks for your answers.
@Amit Langote: I had a look and found out that pg_bigm doesn't support similar
matches
@Dann Corbit: The idea with the sequences makes sence. I had a look and I'm not
sure, if they support similar sequences
Janek
--
Sent via pgsql-general mailing list (pgsql-genera
Hi,
I'm searching for an algorithm/Index to find similar sentences in a database.
The Fulltextsearch is not really suitable because it doesn't have a tolerance.
The Levenshtein-distance ist to slow.
I also tried pg_trgm module, which works with tri-grams, but it's also very
slow with 100.000+
Hi,
Im searching for a suitable Index for my query witch compares Strings with the
Levenshtein distance.
I read that a prefix index would fit, but I dont know how to build it. I only
know that its supported by Gist.
I couldn't find an instructions so I hope someone can help me.
Best regards,
Hi,
I'm searching for a suitable Index for my query witch compares Strings with the Levenshtein distance.
I read that a prefix index would fit, but I don't know how to build it. I only know that its supported by Gist.
I couldn't find an instructions so I hope someone can help me.
Best regard
49 matches
Mail list logo
