MIME-Version: 1.0
In-Reply-To: 
 <CAMpxBo=M35hcH1g4Vg=KRJ0-77FOJcvdrdiVF5KSOAdOG-LvKQ@mail.gmail.com>
References: 
 <CAMpxBo=M35hcH1g4Vg=KRJ0-77FOJcvdrdiVF5KSOAdOG-LvKQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 8 Nov 2023 10:21:20 -0700
Message-ID: 
 <CAKFQuwZ0+0GyZytpska6ybFNHLBKg9GKr_czPvBmhg6uQmh2ow@mail.gmail.com>
Subject: Re: DEFAULT in update & prepared statements
To: Sanjay Minni <sanjay.minni@gmail.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d4cabb0609a75089"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZ0%2B0GyZytpska6ybFNHLBKg9GKr_czPvBmhg6uQmh2ow%40mail.gmail.com>
Precedence: bulk

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

On Wednesday, November 8, 2023, Sanjay Minni <sanjay.minni@gmail.com> wrote=
:

> Can DEFAULT (defined for a timestamp column as now() ) be used in
> 1. prepared statement i.e. EXECUTE ( ..., DEFAULT, ...)
> 2. in an UPDATE statement  UPDATE TABLE SET update_time =3D DEFAULT ..
>

5 seconds looking at the syntax for update in the docs answers the second
question.

The first question doesn=E2=80=99t really make sense - but regardless of wh=
at you
are trying to communicate there just try it.  If the result you get doesn=
=E2=80=99t
make sense post what you tried.

David J.

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

On Wednesday, November 8, 2023, Sanjay Minni &lt;<a href=3D"mailto:sanjay.m=
inni@gmail.com">sanjay.minni@gmail.com</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-f=
amily:verdana,sans-serif">Can DEFAULT (defined for a timestamp column as no=
w() ) be used in</div><div class=3D"gmail_default" style=3D"font-family:ver=
dana,sans-serif">1. prepared statement i.e. EXECUTE ( ..., DEFAULT, ...)<br=
>2. in an UPDATE statement=C2=A0 UPDATE TABLE SET update_time =3D DEFAULT .=
.</div></div></blockquote><div><br></div><div>5 seconds looking at the synt=
ax for update in the docs answers the second question.</div><div><br></div>=
<div>The first question doesn=E2=80=99t really make sense - but regardless =
of what you are trying to communicate there just try it.=C2=A0 If the resul=
t you get doesn=E2=80=99t make sense post what you tried.</div><div><br></d=
iv><div>David J.</div><div>=C2=A0</div>

--000000000000d4cabb0609a75089--