On Sat, Sep 16, 2023 at 1:06 AM Nathan Bossart wrote:
>
> On Thu, Sep 14, 2023 at 03:04:19PM -0700, Nathan Bossart wrote:
> > The only reason I didn't apply this already is because IMHO we should
> > adjust the worker types and the documentation for the view to be
> > consistent. For example, the
On Sep 15, 2023, at 20:36, Tom Lane wrote:
> I think that that indicates that you're putting the info in the
> wrong place. Perhaps the right answer is to insert something
> more explicit in section 11.2, which is the first place where
> we really spend any effort discussing what can be indexed.
On Sep 15, 2023, at 23:59, Erik Rijkers wrote:
> movie @? '$ ?($.year >= 2023)'
>
> I believe it is indeed not possible to have such a unequality-search use the
> GIN index. It is another weakness of JSON that can be unexpected to those
> not in the fullness of Knowledge of the manual. Yes, t
On Sep 12, 2023, at 21:00, Erik Wienhold wrote:
>> If so, I’d like to submit a patch to the docs talking about this, and
>> suggesting the use of jsonb_path_query() to test paths to see if they return
>> a boolean or not.
>
> +1
I’ve started work on this; there’s so much to learn! Here’s a new
On Sat, Sep 16, 2023 at 06:09:48PM +0530, Amit Kapila wrote:
> I think there is a merit in keeping the worker type as 'sync' or
> 'synchronization' because these would be used in future for syncing
> other objects like sequences. One more thing that slightly looks odd
> is the 'leader apply' type o
On 16/09/2023 22:19 CEST David E. Wheeler wrote:
> On Sep 15, 2023, at 23:59, Erik Rijkers wrote:
>
> > movie @? '$ ?($.year >= 2023)'
> >
> > I believe it is indeed not possible to have such a unequality-search use
> > the GIN index. It is another weakness of JSON that can be unexpected to
> >
On Sep 16, 2023, at 16:50, Erik Wienhold wrote:
> "For these operators, a GIN index extracts clauses of the form
> **accessors_chain = constant** out of the jsonpath pattern, and does the
> index search based on the keys and values mentioned in these clauses."
>
> I don't know if this is a gener
On 16/09/2023 22:26 CEST David E. Wheeler wrote:
> I’ve started work on this; there’s so much to learn! Here’s a new example
> that surprised me a bit. Using the GPS tracker example from the docs [1]
> loaded into a `:json` psql variable, this output of this query makes perfect
> sense to me:
>
>
On Sep 16, 2023, at 18:13, Erik Wienhold wrote:
> Looks like the effect of lax mode which may unwrap arrays when necessary [1].
> The array unwrapping looks like the result of jsonb_array_elements().
>
> It kinda works in strict mode:
>
> SELECT jsonb_path_query(:'json', 'strict $.track.segment
On Sat, Sep 16, 2023 at 9:03 AM Andres Freund wrote:
>
> Hi,
>
> On 2023-08-28 23:43:22 +0900, Masahiko Sawada wrote:
> > I've attached v42 patch set. I improved tidstore regression test codes
> > in addition of imcorporating the above comments.
>
> Why did you need to disable the benchmark module
Op 9/14/23 om 10:14 schreef Amit Langote:
Hi Amit,
Just now I built a v14-patched server and I found this crash:
select json_query(jsonb '
{
"arr": [
{"arr": [2,3]}
, {"arr": [4,5]}
]
}'
, '$.arr[*].arr ? (@ <= 3)' returning anyarray WITH WRAPPER) --crash
;
server closed the co
11 matches
Mail list logo
