Re: Longest Common Subsequence in Postgres - Algorithm Challenge

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Longest Common Subsequence in Postgres - Algorithm Challenge
Дата
Msg-id 20130708144518.GA13082@depesz.com
обсуждение исходный текст
Ответ на Longest Common Subsequence in Postgres - Algorithm Challenge  (Robert James <srobertjames@gmail.com>)
Ответы Re: Longest Common Subsequence in Postgres - Algorithm Challenge  (Robert James <srobertjames@gmail.com>)
Список pgsql-general
On Mon, Jul 08, 2013 at 09:09:26AM -0400, Robert James wrote:
> I have two relations, where each relation has two fields, one
> indicating a name and one indicating a position.  That is, each
> relation defines a sequence.
>
> I need to determine their longest common subsequence.  Yes, I can do
> this by fetching all the data into Java (or any other language) and
> computing it using the standard LCS dynamic programming language.  But
> I'd like to stay within Postgres.  Is there any way to do this?

I'm not entirely sure I understand. Can you show us some sample data and
expected output?

Best regards,

depesz



В списке pgsql-general по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: replication stops working
Следующее
От: pg noob
Дата:
Сообщение: Re: odd locking behaviour