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.96) (envelope-from ) id 1vT5hj-00CfD8-2Z for pgsql-general@arkaria.postgresql.org; Tue, 09 Dec 2025 21:57:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vT5hi-007UYj-0o for pgsql-general@arkaria.postgresql.org; Tue, 09 Dec 2025 21:57:06 +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.96) (envelope-from ) id 1vT5hh-007UYb-2z for pgsql-general@lists.postgresql.org; Tue, 09 Dec 2025 21:57:06 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vT5hg-0047Xe-0z for pgsql-general@lists.postgresql.org; Tue, 09 Dec 2025 21:57:05 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-3ec31d2b7f8so2395914fac.3 for ; Tue, 09 Dec 2025 13:57:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765317422; x=1765922222; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=UQii32pmWWPh3FDL82pL+ZVnX1iQ7efFNrC0QkDrGO8=; b=KLzTd/ipKcMgpBgv250K8q3SdRLcQ5SBKzbXUw28JZsq7yXJTBfV8Q3EvNYy8J0s1a mTz+NYr+TX0NnLv10AukU83Ad/Oc3qjEoNxKZ4TPjVVNV1nkwVWBEqLz0wCw0OAeWr94 /FSIPqfpNZdu9zEkfsX7IZOajIF8pJYryZSQbhPb0yEMxVMDtx6zwd8TFdCQy/wvAex2 xdrheU4tgaAobchQuQO1tYIrWyD004jtb9B8haiMQHaRLkcFRmRXgx17t/W4XdqnRUX0 MMX0HstMxiLd63vptLBVldWwzXF+bWHJGpJp2FKIFJD8nVHEUzTqLeFThTvfbwOPnsQo 4I/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765317422; x=1765922222; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=UQii32pmWWPh3FDL82pL+ZVnX1iQ7efFNrC0QkDrGO8=; b=m2AVgnVM52K7ytSyZY6LMi4IVFpWuy+L2FnoBL8w1zofnprG1hTWbCSr2zTiWAg6fd 0Z+NhnWmo+uf+BJw/5RdYj14JiJXI7n+PKPtS0yn5B0HdWAy2M/uL7T4bg2LsbPOugIE pilLwYq62ZYXJhUdpYFdYURdnU6j3KFi+uC+BvXtrCDHSG1EIAVGx6vT/ETV7QCUvR77 jPLS+AEDwS55Fp4LfsB5Nm3iFQHbb7axkywb7yjWbvNQ9oYVHkEDlR/H9vHEntaeod+I OxHc+SCI66d5/jQVAjprIxH1xYHMPqhjf51x3poI9fiKsY44A4rBjQZ3dR4q4BYMZnPp UgNg== X-Forwarded-Encrypted: i=1; AJvYcCX6W1XmJ20VSklOwp5zw6NmKN9q3/YIJEuSq65YrbWLsyHTt3Tlom9SgPw3lCJxOiOf0I2e7a3tSen0YSO1@lists.postgresql.org X-Gm-Message-State: AOJu0Yxj1NQxlOAvnVms+JUD+lbALBYqAkndEHT/iYbybzO2jl39+NMq De7gjdmu5eEXEzWwTn15yNsSyKN/DU0w8NLw98CMiOGQpHEMXZBo4Yvc3L64Fe7NbASVPMnj/UP +5Dq+MCd6b81HdXTiptdgYyr31O6j3jA= X-Gm-Gg: ASbGnctN7H3wubWk69mC7+mKKkUeNgUlfbw2bQsi9GX61dYelFawGmPhL0VHh9FUmo1 9FKR/SkIaK3iUHp9SwvaZQqeIv6BxtXitATjj0YEmN8hQvXpwZMVHmkbXhCrlN0Vq4u9U94zLpf 1eMWDbFaAa6X0UEzCBahP1q9O+falBwsSju+pro2CZhb+MYCNFMd/Z9ftc9GXgjGKpwmrbCD3ue OvcwsaURSPRiTEJ2B8ZN0WlrzH9hiWdpp+Lyaophf6BS14ojPqaw7U+NoFm0oHZ7bNuF4+vgM/I Pn47 X-Google-Smtp-Source: AGHT+IGvgZFcpecoOi8DDxFdrJEPcG4+RLJrIwGHNulgbcMBgvc2J+aU0Qp99R4o0PWR0ZA5mzAiFk7UqJcFiAYRufE= X-Received: by 2002:a05:6820:2019:b0:659:9a49:8dc6 with SMTP id 006d021491bc7-65b2abb3140mr218818eaf.8.1765317422396; Tue, 09 Dec 2025 13:57:02 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Tue, 9 Dec 2025 14:56:24 -0700 X-Gm-Features: AQt7F2rtymj7oHsxEvdEdV3T0EfUAcVr7mz3aYBe4XX5syOqJQy4ZvX-YiRFLV0 Message-ID: Subject: Re: How do I check for NULL To: Juan Rodrigo Alejandro Burgos Mella Cc: Igor Korot , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000e0b74d06458bfd4b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e0b74d06458bfd4b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Dec 9, 2025 at 1:40=E2=80=AFPM Juan Rodrigo Alejandro Burgos Mella = < rodrigoburgosmella@gmail.com> wrote: > > Did you try setting a default value to the field? > >> >> Defaults don't work if you actually intend to conditionally override them -- or at least it requires something beyond a simple self-contained SQL command to accomplish. David J. --000000000000e0b74d06458bfd4b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Dec 9, 2025 at 1:40=E2=80=AFPM Juan Rodrigo Alejan= dro Burgos Mella <rodrig= oburgosmella@gmail.com> wrote:

Did you try setting a default val= ue to the field?


=
Defaults don't work if you actually intend to conditionally ov= erride them -- or at least it requires something beyond a simple self-conta= ined SQL command to accomplish.

David J.

<= /div>
--000000000000e0b74d06458bfd4b--