Sha256: 4b79870f5eb10954e184477b55ca3878b75b463df18b29925347ae07001e2c39

Contents?: true

Size: 752 Bytes

Versions: 89

Compression:

Stored size: 752 Bytes

Contents

/* The mandelbrot set */

WITH RECURSIVE Z(IX, IY, CX, CY, X, Y, I) AS (
          SELECT IX, IY, X::float, Y::float, X::float, Y::float, 0
          FROM (select -2.2 + 0.031 * i, i from generate_series(0,101) as i) as xgen(x,ix),
               (select -1.5 + 0.031 * i, i from generate_series(0,101) as i) as ygen(y,iy)
          UNION ALL
          SELECT IX, IY, CX, CY, X * X - Y * Y + CX AS X, Y * X * 2 + CY, I + 1
          FROM Z
          WHERE X * X + Y * Y < 16::float
          AND I < 100
    )
SELECT array_to_string(array_agg(SUBSTRING(' .,,,-----++++%%%%@@@@#### ', LEAST(GREATEST(I,1),27), 1)),'')
FROM (
      SELECT IX, IY, MAX(I) AS I
      FROM Z
      GROUP BY IY, IX
      ORDER BY IY, IX
     ) AS ZT
GROUP BY IY
ORDER BY IY;

Version data entries

89 entries across 89 versions & 2 rubygems

Version Path
ruby-pg-extras-5.6.7 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.6 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.5 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.4 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.3 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.2 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.1 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.6.0 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.5.1 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.5.0 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.4.5 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.4.4 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.4.3 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.4.2 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.4.1 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.4.0 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.3.1 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.3.0 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.2.5 lib/ruby_pg_extras/queries/mandelbrot.sql
ruby-pg-extras-5.2.4 lib/ruby_pg_extras/queries/mandelbrot.sql