Re: Solving sudoku using SQL

On Thu, Dec 9, 2010 at 11:56 AM, Dimitri Fontaine
<dimitri@2ndquadrant.fr> wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
>> On Wed, Dec 8, 2010 at 8:57 AM, Tatsuo Ishii <ishii@postgresql.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