Postgres Pro
Downloads
Home   >   mailing lists

Re: Solving sudoku using SQL - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Solving sudoku using SQL
Date
Msg-id AANLkTi=eaq__PPR9Ph_Ek5DM_TszjJ=Xq8Au0SbNjhWB@mail.gmail.com
Whole thread Raw
In response to Re: Solving sudoku using SQL  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Solving sudoku using SQL
Next
From: Tim Bunce
Date:
Subject: Re: Optimize PL/Perl function argument passing [PATCH]