Re: IS JSON predicate support for domain base type as JSON/JSONB/BYTEA/TEXT

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: jian he <jian(dot)universality(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: IS JSON predicate support for domain base type as JSON/JSONB/BYTEA/TEXT
Date: 2026-03-13 12:30:27
Message-ID: 5406c2b1-57c8-448b-97c7-8af295ba3869@dunslane.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

Attachment Content-Type Size
v4-0001-Allow-IS-JSON-predicate-to-work-with-domain-types.patch text/x-patch 11.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2026-03-13 12:36:16 Re: client_connection_check_interval default value
Previous Message Greg Sabino Mullane 2026-03-13 12:24:04 Re: Exit walsender before confirming remote flush in logical replication