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 1r0l10-007egD-Ca for pgsql-sql@arkaria.postgresql.org; Wed, 08 Nov 2023 16:02:50 +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 1r0l0y-005cC8-Rc for pgsql-sql@arkaria.postgresql.org; Wed, 08 Nov 2023 16:02:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0l0y-005cAY-I7 for pgsql-sql@lists.postgresql.org; Wed, 08 Nov 2023 16:02:48 +0000 Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0l0w-004aZq-7R for pgsql-sql@lists.postgresql.org; Wed, 08 Nov 2023 16:02:47 +0000 Received: by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-2c6efcef4eeso86309471fa.1 for ; Wed, 08 Nov 2023 08:02:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699459364; x=1700064164; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=buAo6G8zaYgqvvd5Yk3hwnnmfTpLDlZkUwJP5FLhVlk=; b=fXZN/4706Tz5KFScP+S+Tk9W9/MDq7ZTTY21xH+dakYWjjUbg4biOw6X1IRGHRsorA OBkA0CrZi4gLF0J1a/aIErHVuKT8qjD9RmoT44jwQOyAfpQrtSM2fDRtrquJDfnyX77y v/p+6ctV+jFFdvml5K7zaMXIRMLPs17O649GaWdwx98P/+OwwcLilr4NLNmUYOdLS46E gcEmgSD0L/uJZu5LwJLCzKCrIePifRD5vh+HFX0gN+NqnhFk9F34OUxlfpBMjVLCNTxZ jHA6mjIQfKR6RtbSCaKNLBTaIsaq4SsMS57/ygsgifPh1aB+cakPk/l3fuxB6ux33cla OCsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699459364; x=1700064164; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=buAo6G8zaYgqvvd5Yk3hwnnmfTpLDlZkUwJP5FLhVlk=; b=cxlznXjRw5xIRh7Sw8NcsqoK2jH3NmjcubTUJQ6IztnivEfn+/u9mrW3htSrTzLtAI ysXRzLD0EaQiAWZVuRzCjFBbe7Ts2kdA4tjCj1F7dq04X1E7JKGjjofdIsNo9CAYfZuz 6jzbDmr1oyg6hfP3I5U0Y2lt41pDk2NTIwc5Y1njYqTdsHp99+NirvQAVXDU6vG+k2/U m0kpfwagL58dKFjkPBc/3KQNfmk2EAawV/SkGSeH8O8B7AL5nELZ8es4TmCZRh3oznzH UaNydrhW9ZgYNkxye36VuA+taeV7yJfPwpzAZA1Ci10nmCMVx6ZGEIigOu0p8199dIG6 zg0A== X-Gm-Message-State: AOJu0YzvfbdckuiLAleUmNI/h0EzYxlf1VkajHcpYs+qqgTIZsxnAkYB Mu8B3wzltHVK6jwcCgHLin7+wde2Tmr48czOBJsevPfI804= X-Google-Smtp-Source: AGHT+IGeHx5xMc4Ea3Ec3n/3lS4pxYZFssD83lz2mCuX030wyr+qkSXi6HFUC9Pe8Koku/76B4CXFzgmzEP43SHkoLA= X-Received: by 2002:ac2:43da:0:b0:4ff:7f7f:22e7 with SMTP id u26-20020ac243da000000b004ff7f7f22e7mr1630204lfl.17.1699459363945; Wed, 08 Nov 2023 08:02:43 -0800 (PST) MIME-Version: 1.0 From: Sanjay Minni Date: Wed, 8 Nov 2023 21:32:16 +0530 Message-ID: Subject: DEFAULT in update & prepared statements To: pgsql-sql@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000b2c2840609a63730" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b2c2840609a63730 Content-Type: text/plain; charset="UTF-8" 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 = DEFAULT ... thanks Sanjay --000000000000b2c2840609a63730 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Can DEFAULT (defined for a timestamp column as now() ) be used = in
1. prepared statement i.e. EXECUTE ( ..., DEFAULT, ...)
2. in an UPDA= TE statement=C2=A0 UPDATE TABLE SET update_time =3D DEFAULT ...

<= div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif">thanks=
Sanjay
--000000000000b2c2840609a63730--