From 250201b433c0a99f6cabcb2596bfe43f1a5a3968 Mon Sep 17 00:00:00 2001
From: alex <alex@pdp7.net>
Date: Fri, 13 Oct 2023 16:11:25 +0200
Subject: Moving to prod!

---
 blog/content/2011/12/upserts.gmi | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 blog/content/2011/12/upserts.gmi

(limited to 'blog/content/2011/12/upserts.gmi')

diff --git a/blog/content/2011/12/upserts.gmi b/blog/content/2011/12/upserts.gmi
new file mode 100644
index 00000000..a163de5b
--- /dev/null
+++ b/blog/content/2011/12/upserts.gmi
@@ -0,0 +1,11 @@
+# Upserts...
+2011-12-17
+
+Trabajando en un pequeño experimento[1], se me ha ocurrido un insert idempotente:
+
+insert into foo (bar) (select 'bar_value' as bar where not exists (select 1 from foo where bar = 'bar_value'));
+
+(la sintaxis es de PostgreSQL, pero supongo que es adaptable a otras bases de datos). Igual intento adaptarlo a hacer upserts.
+
+
+=> https://github.com/alexpdp7/tvguide 1: https://github.com/alexpdp7/tvguide
\ No newline at end of file
-- 
cgit v1.2.3