MIME-Version: 1.0
In-Reply-To: <CAEzWdqeW+yVwb2v8Vy-t9DC69_cMhUWTQqVBoL7_9qDzhBe8=Q@mail.gmail.com>
References: <CAEzWdqc=QKpfFU3jNSoBrZ37y727GK2w2rSQ2qJCEGJDT5Pm6Q@mail.gmail.com>
 <37e09717-f121-4192-b152-18df17713414@aklaver.com> <CAEzWdqeW+yVwb2v8Vy-t9DC69_cMhUWTQqVBoL7_9qDzhBe8=Q@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 10 Aug 2024 06:49:30 -0700
Message-ID: <CAKFQuwZBRWuVE5mz4ZTZ3Y2t=RMkSdxG7-UXV7aHLwFuM2-KOA@mail.gmail.com>
Subject: Re: Insert works but fails for merge
To: yudhi s <learnerdatabase99@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007d5676061f548769"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZBRWuVE5mz4ZTZ3Y2t%3DRMkSdxG7-UXV7aHLwFuM2-KOA%40mail.gmail.com>
Precedence: bulk

--0000000000007d5676061f548769
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, August 10, 2024, yudhi s <learnerdatabase99@gmail.com> wrote:

>
> In our case , we were using this merge query in application code(in Java)
> as a framework to dynamically take these values as bind values and do the
> merge of input data/message.
>

I=E2=80=99d do most anything before resorting to dynamic SQL.  Usually one =
can
simply write:  values ($1::timestamptz) without resorting to a catalog
lookup.

Or maybe write a function to do the merge.  Or maybe insert to a temporary
table then merge that.

David J.

--0000000000007d5676061f548769
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, August 10, 2024, yudhi s &lt;<a href=3D"mailto:learnerdatabase=
99@gmail.com">learnerdatabase99@gmail.com</a>&gt; wrote:<br><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"g=
mail_quote"><div>In our case , we were using this merge query in applicatio=
n code(in Java) as a framework to dynamically take these values as bind val=
ues and do the merge of input data/message.=C2=A0</div></div></div></blockq=
uote><div><br></div><div>I=E2=80=99d do most anything before resorting to d=
ynamic SQL.=C2=A0 Usually one can simply write: =C2=A0values ($1::timestamp=
tz) without resorting to a catalog lookup.</div><div><br></div><div>Or mayb=
e write a function to do the merge.=C2=A0 Or maybe insert to a temporary ta=
ble then merge that.</div><div><br></div><div>David J.</div><div><br></div>

--0000000000007d5676061f548769--