Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rbPL1-00FHMT-Lx for pgsql-general@arkaria.postgresql.org; Sat, 17 Feb 2024 18:22:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rbPL0-007bAh-CA for pgsql-general@arkaria.postgresql.org; Sat, 17 Feb 2024 18:22:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rbPL0-007bAZ-1s for pgsql-general@lists.postgresql.org; Sat, 17 Feb 2024 18:22:58 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rbPKx-007hjh-UG for pgsql-general@lists.postgresql.org; Sat, 17 Feb 2024 18:22:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1708194173; x=1708798973; i=karsten.hilbert@gmx.net; bh=Hg7CLVaSJrSRjTFgSBV3BH8smt4gvHVOCw7CySMTQ8Q=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References: In-Reply-To; b=YL//9pVpYaB8ujmvma2ZGNoJenl1UtAnYEeccS8AJ+PVXy9BIvmAhhsjt6AfQWpG dtDR4tdskbeM9cJ6CN5VXG/EecBvXYKxRUokZZRink7zUjoa6vt8vD4b2LO99Aivb q0CWspJc99WFdY2njw/T05WMw+4nSA6GNy5nMpBdIjhPOzaVPg3B92FWOYQPk78Sc OeB5A5bU8IlLgcFBEkri/E3sObv9VrGqopJNnta/3lkSeSNuZ4xjPfYBJTdpbPd8/ TCzCdcOMI1jh6COYLp67Kznj37h29wA1E7MnuMx9xKQI1wp5Qpqzl2vOELO+Iabi+ 26huUPwUHfBz2fx4QQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.207.30]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1N79u8-1qs34D31no-017TdC; Sat, 17 Feb 2024 19:22:53 +0100 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1rbPKv-0001XC-17; Sat, 17 Feb 2024 19:22:53 +0100 Date: Sat, 17 Feb 2024 19:22:53 +0100 From: Karsten Hilbert To: Rob Sargent Cc: pgsql-general@lists.postgresql.org Subject: Re: "reverse" (?) UPSERT -- how to ? Message-ID: References: <5F927293-F62E-41C4-A62B-AB184E91B0F1@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5F927293-F62E-41C4-A62B-AB184E91B0F1@gmail.com> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:EiQwHINcSHOs68pwDTGXuxBzdvNYDt8OMOtQ88Qpep1mqz93n19 xUUxAeFvmv1jJj9uzrwWJTJrNNMgcgxBpgLBtnvbKUY4LTX76SH/MiZFtNoj5fESrhBiTG5 8HozAjJQNNy6yv1DwQrtcld0jG3axZ/BD/ksPziV4NKT7JVphg0mX5Pr6+SSsLL6sGZOq2f 1DQHVdrIrEkguY6Osj22g== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:LqPGC0FN8Z0=;MWfbpdjhqJRLMbph7lNGUOnVIjb Klb1gP5IldgeD1ctAeWaiOjb8htIzIXiH6UxKM7SjfDMU1+aC7TEhl9u0QkjGEijC/Q70KHiS nj8nGAWm8Kafc/k0SEwYNijo1fWV2L0v7AF+gDdwA09UhZ5qC3hjouWDP/JbihqnXAbTxq64Y JCh0w6hwtQDMZf4zaTYz6lR7ZI3Fs1yISA+fuUHRvKq6uNASjmaEsjpdlzSVjoky58+IeQqYE +uOfekMt48XcI0PakLgb6+5PLBDKfwE6/70YOe/0OYLluVk9FezzNY2IhjxpXNLUmWEB1JwPl RiM+eD6zkc6Tm4LpZtS2B1SA/2MkAoQQuhG6LxloPnW64SefuVyzhVlqRpfHgIAXj5ULVLgKb EtomJnRtl+D2mOhmGHIJkwDCj9ZrUrXkYs+qfvZiK3qZGkKG1AZD/YjhMrL3/75nptwgETomY MZPdDHd9c8HiDZ3tk9JgTWf8qvENkeQkOZ4zI5i5MOiQUlX6eHS/GzBk0eklxaPU8GGxjv84q WitHnDHboR0uCNWsrBwWoYrsQrVgeq5MBI44KSABHv2wyMaqlUTErWppXNkpDWaWT7Tg7UUM6 tseTreDXqejo4QDad872NT0+pR8tPebxYZ0LZnqk8NQgSFGShR/XdYUn6hXbrcq8Vnxa/4Pag xNaQzpFZ+0DHOay1DAQBGui2lr0k/lIyO2ftfsOrFKcD7IJ6ZjYfJxzcYw1s0Rblctp8AWvbw XlP0g6jATo9q5rWrX/FzpUU0U/DmT7n563BQKbrPP8kFRb9JRyHwwfZI6q+X9hChKNn82FQ8X 9GPTQ37V1Rnyu2J3+flTriq5QSxccw5QXzyrPts5nZD0A= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Sat, Feb 17, 2024 at 09:33:11AM -0700 schrieb Rob Sargent: > > So, is this doable within one SQL statement (short of > > creating and running the abovementioned function in > > one go ;-) ? > > > > Perhaps your pk_detail can be defined as generated always identity? Rob, I'm sure there's something to be learned from that suggestion the significance of which I don't grasp yet. Would you mind expanding a bit ? Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B