Re: Solving sudoku using SQL

On Thu, Dec 9, 2010 at 11:56 AM, Dimitri Fontaine
<dimitri(at)2ndquadrant(dot)fr> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> On Wed, Dec 8, 2010 at 8:57 AM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>>>
>>> Then execute the huge SELECT:
>>> http://codezine.jp/static/images/article/1629/html/sql.html
>>
>> benchmark what you've got against this (ported to postgres by marcin mank):
>> http://www.pastie.org/684163
>
> It that this one ?
>
> http://archives.postgresql.org/message-id/e08cc0400911042333o5361b21cu2c9438f82b1e55ce@mail.gmail.com

sure is -- I missed the formatted version. The original query also
an Oracle original. If you remove the 'where ind = 0', you can watch
the database solve the puzzle, which is pretty neat.

merlin