From 87df74b49c8792e9dddd550d862b2cfa9a2e909b Mon Sep 17 00:00:00 2001 From: alex Date: Fri, 13 Oct 2023 16:02:34 +0200 Subject: Adapt to new layout --- blog_experiment/content/2011/12/upserts.gmi | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 blog_experiment/content/2011/12/upserts.gmi (limited to 'blog_experiment/content/2011/12/upserts.gmi') diff --git a/blog_experiment/content/2011/12/upserts.gmi b/blog_experiment/content/2011/12/upserts.gmi new file mode 100644 index 00000000..a163de5b --- /dev/null +++ b/blog_experiment/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