Re: JSON Path and GIN Questions

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: Erik Wienhold <ewie(at)ewie(dot)name>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: JSON Path and GIN Questions
Date: 2023-09-13 20:01:03
Message-ID: C4BBA1CB-9EA1-4124-8CAD-8DDD646C453F@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sep 13, 2023, at 01:11, Erik Rijkers <er(at)xs4all(dot)nl> wrote:

> "All use of json*() functions preclude index usage."
>
> That sentence is missing from the documentation.

Where did that come from? Why wouldn’t JSON* functions use indexes? I see that the docs only mention operators; why would the corresponding functions behave the same?

D

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chapman Flack 2023-09-13 21:18:16 Re: Extract numeric filed in JSONB more effectively
Previous Message Andres Freund 2023-09-13 19:32:46 Re: [PATCH] Add native windows on arm64 support