aboutsummaryrefslogtreecommitdiff
path: root/src/mandelbrot.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/mandelbrot.sql')
-rw-r--r--src/mandelbrot.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/src/mandelbrot.sql b/src/mandelbrot.sql
index 1c25461..b83b751 100644
--- a/src/mandelbrot.sql
+++ b/src/mandelbrot.sql
@@ -1,5 +1,4 @@
-DELETE FROM images WHERE id = 'mandelbrot';
-INSERT INTO images (id, width, height) VALUES ('mandelbrot', 400, 400) RETURNING id;
+INSERT OR REPLACE INTO images (id, width, height) VALUES ('mandelbrot', 400, 400) RETURNING id;
WITH RECURSIVE
image AS (SELECT *, 0.008 AS scale, (width * 5)/7 AS ox, (height / 2) AS oy FROM images WHERE id = 'mandelbrot'),