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 1w12Nl-002RAp-2t for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 13:16:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w12Nk-0047yL-1I for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 13:16: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.96) (envelope-from ) id 1w12Nj-0047yC-37 for pgsql-hackers@lists.postgresql.org; Fri, 13 Mar 2026 13:16:48 +0000 Received: from mail-qt1-x830.google.com ([2607:f8b0:4864:20::830]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w12Ni-00000001wUJ-3A5Y for pgsql-hackers@postgresql.org; Fri, 13 Mar 2026 13:16:47 +0000 Received: by mail-qt1-x830.google.com with SMTP id d75a77b69052e-506a7bbe9d0so19881941cf.0 for ; Fri, 13 Mar 2026 06:16:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773407806; cv=none; d=google.com; s=arc-20240605; b=Hufum+xXc7Agr2xAv21vRgmlzkYaY+QyQDzTMka5CNy9MY7AFlFWWM0Hf+8EWmHZu6 SB5W3eO3wUCsCOpPVNPALHAQOYfpWdo09AgQ2ebWw9Vk7XImuVKGHrEt7lkayulW/mEn HTUEfhxRp4EHPj/uP2iVVohaIYnJEtuZvDVKnVVyEDHlaW2nE9w+hI3Epv6o3Oqx1Rwq svkFO5T12cnVwVVJDQ9n9ct8v3HEUx08g1ra4+ikF+itsVcZKyfmXxcUcu9z52Pqar04 FfACsUVVXt9594QmsB3QbCEQkR5h0px4oQ43/nZZNV74L0VQ0EpMUCAXcn5x7dNm0imj xCTA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=7Cej8HOq9pFjAkUUwtfpDTFCJKh/fIe0ngu5McdBL6A=; fh=ZxDuwPeEP+R9KaFda7WvRVWcHRx+HUV51wP9AM4nVsM=; b=e/fLurAznLaY33nvB4zioUgQ1hYoY8ZQ0PFTURyph2vW7RO6Dckf2S3lVORdDme15n p6uWZ5heswRHS70YW7IPSe5ttVTWsuSDWXN1td4XP9DZ0eB9zccGz3kUhnj4GkrxvYj5 wV6o2OX+/nywRIF0A+4a6wxwNM6MUxP3MUmLnx1LW+JclJPqP8F9ujXxjguwUqPhvVHt VeYCrWPpLNzmoAxoNqaIwbow+OsBZO3oTmBKap6UzyQu9V7kCDP/HKxNCGNL7syOxa6e ZSH4JRhV4XkWcPDR7easGskwDe46zGS2jzWzFjuRnMPZlh1VYAs/NWc+OimzE5rUOnaZ 9tBQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773407806; x=1774012606; darn=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=7Cej8HOq9pFjAkUUwtfpDTFCJKh/fIe0ngu5McdBL6A=; b=fGq+jjJhcU8e9KQs4lpHZTuDkcxAJ2S3kKOB19FFxNHzSCxYH1kGSZQV0JPJd8PB1l bfzv9GuHrrmUXT016BjsHgX1h+6u6y7iu61/+/AIte4eino6jBJN3M3UsrG+0XlHBQvl Y+9fDZWEgZSb62eOBte/XKjWs5Ojz6hqs0NEaGMKSrC960N5FdEqK2DdWbpiYj2QiS3Y elN801EsHcAYKLWeMP0DtmCcIPXXqSf0CHThyx9hWfxuVNgBDgun64f4EKVWyNcdPfZ+ HDB55VNyM4TGnwSbfnev84d9Ua+ZwVYVA1Gyyj4WnoADodsT7PpMTME11sPQo/JH5z0f j//g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773407806; x=1774012606; 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=7Cej8HOq9pFjAkUUwtfpDTFCJKh/fIe0ngu5McdBL6A=; b=rGENgw11l+ROYIHXEqLUmVjfIrC7n0pDXG4/3Q3Lc7Xz68bUmVInvn0fbiFwt2q0Vu MwMbAqhfUtnkWR6E69GD4Nvd7oXzdyexpSiiCoXrzFQkyHewUAOwvo0OMAFkdDpsVHr8 6HWXTOruzjfpyIeIA/ZrviyyNnO+ZEI5aM5pz6SvjEPdiUPgY1GwsWvcNK7o7f7MsZPB 9PK4yAvQIWNoNUOToHQg2P9kLifljWmfCrirj3WvvUP0/ffoJ56gTvUeYdTDLnHEqFEt 76Sv3j16dxMw+PZtpMn69Gz0PCcgOK9C6ugm152blqcMYeO1kwnGWRvSdYS/2Ex2y0oZ Q5xg== X-Forwarded-Encrypted: i=1; AJvYcCVrHssf+1P2uieiyUTQ+Ruxt33aOwFAbsFWFFI2nw1/7E44kt6zo+FJpjI75coxFMbmDmtXspSItDflj++v@postgresql.org X-Gm-Message-State: AOJu0YzGFZuZNZSyYy886GGdA6bvk6Pp/aN8SH8sqYsvCK6dKTL4JA8x 0aOlXG8l3bfKgkC+P0uCDpkZNRYD67PqpTYC8oVrbf+LL1OhuDUSUTYDpUyH1jqL2+Juk3eDPuF p8UW7sRltH39GRNkfr0w/Ayv1bnEyQ8I= X-Gm-Gg: ATEYQzxxgu2dQchHZCFzLM5LDsWWNWtHedM9w4BrunIF+yZq/iTCjZEtyyBs+breEum oz3VoUMccAS+7RfCOIW+JLosL/eMNO9gICvXp125nVvebSXEguXJqd7U5U4EooDKBxRVC5sP/0F kTo9kecQ8iQsklrV3Q7GIfpuNKHWWYJZLvUQt8SngbcrfP52MS7ftxy4W87IVY6hOivSkxf5BzB msGRDm1bmmL2QFJ1FJ1+pmqPr0eypaXaQYMktP2GZphWEI5vANANBYWrX0/NyW9gs+0X11MHAd2 P9zuAc9C2pN6UZOO7fxcnzfppesV2khbTgNS/VlvkenFm8ODG7jlwWy/lQWzu+UoZIuXd6Cmo2j lL2FI X-Received: by 2002:ac8:5713:0:b0:509:107e:c46e with SMTP id d75a77b69052e-50957cdfb78mr40037041cf.20.1773407805843; Fri, 13 Mar 2026 06:16:45 -0700 (PDT) MIME-Version: 1.0 References: <1118236.1763485279@sss.pgh.pa.us> <5406c2b1-57c8-448b-97c7-8af295ba3869@dunslane.net> In-Reply-To: <5406c2b1-57c8-448b-97c7-8af295ba3869@dunslane.net> From: Kirill Reshke Date: Fri, 13 Mar 2026 18:16:34 +0500 X-Gm-Features: AaiRm521UObhggVMuzfIfeqZpfXUV2i8YdjZZx48i9Gex8O4Ihr7EDoy7IjRflA Message-ID: Subject: Re: IS JSON predicate support for domain base type as JSON/JSONB/BYTEA/TEXT To: Andrew Dunstan Cc: jian he , Tom Lane , PostgreSQL-development Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 13 Mar 2026 at 17:30, Andrew Dunstan wrote: > > > On 2026-03-12 Th 11:55 PM, jian he wrote: > > Hi. > > > > The regression test was very verbose; I removed some of it. > > Also polished function ExecEvalJsonIsPredicate a little bit. > > > > Here's a v4. I changed resultBaseType to exprBaseType - I think it's > clearer. I also trimmed the tests a bit more, and dropped the new > objects after testing them. The error message now shows the domain name > rather than the underlying base type. I think that's more useful. > Hi! V4 looks good. The only thing that I cannot explain is removing the `exprtype` variable inside ExecEvalJsonIsPredicate. We can just change its declaration to exprtype = pred->exprBaseType if i'm not mistaken? Anyway, LGTM > -- > Andrew Dunstan > EDB: https://www.enterprisedb.com -- Best regards, Kirill Reshke