From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Finding matching words in a word game |
Date: | 2013-03-05 09:29:29 |
Message-ID: | CAADeyWgZjZfQ0qsxobewSjhARan5T-fu50tf6gMf3ZsR4OjBug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
is there maybe a clever way of finding all possible words
from a given set of letters by means of PostgreSQL
(i.e. inside the database vs. scanning all database
rows by a PHP script, which would take too long) -
if the dictionary is kept in a simple table like:
create table good_words (
word varchar(16) primary key,
stamp timestamp default current_timestamp
);
I could add a column above, where same letters as in "word"
would be sorted alphabetically... but then I don't know.
I've described my question in more detail at
http://stackoverflow.com/questions/15220072/postgresql-and-word-games
Thank you for any suggestions
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Farber | 2013-03-05 09:59:09 | Re: Finding matching words in a word game |
Previous Message | Albe Laurenz | 2013-03-05 08:30:10 | Re: 9.2 timestamp function syntax error |