Tagged Questions
1
vote
2answers
40 views
Dropping a group of schemas with similar name patterns
Consider a situation where one need to perform a bunch of essentially identical operations, with the only variable being the name of some object.
In my case, I need to drop some schemas, all of the ...
1
vote
0answers
46 views
PostgreSQL Fuzzymatching Error
I get such errors when using these functions, what's is wrong?
pgdb=# SELECT distance('foo','zoo');
ERROR: parse error - invalid geometry
LINE 1: SELECT distance('foo','zoo');
...
0
votes
1answer
77 views
PostgreSQL 8.4 no levenshtein fuzzymatching?
I'm using debian squeeze package, it says function does not exist?
1
vote
1answer
101 views
Pattern similarity in time-series
I have a PostgreSQL database and my data-set include time-series of temperature for two stations. I would like to look their pattern's similarity in similar time sequences.
For station number 1:
...
6
votes
4answers
3k views
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
I had to write a simple query where I go looking for people's name that start with a B or a D :
SELECT s.name from
spelers s
WHERE s.name LIKE 'B%' or s.name like 'D%'
order by 1
I was wondering ...
8
votes
3answers
655 views
How is LIKE implemented?
Can anyone explain how the LIKE operator is implemented in current database systems (e.g. MySQL or Postgres)? or point me to some references that explain it?
The naive approach would be to inspect ...
