Re: Incorrect EXPLAIN ANALYZE output in bloom index docs

2024-12-09 Thread Yan Chengpeng
> On Dec 9, 2024, at 15:53, David Rowley wrote: > > I was fixing up the patch in [1] with the intention of committing it > when I noticed that there are a few outdated EXPLAIN ANALYZE examples > in the documents for the bloom contrib module. > > The example outputs look like they've been creat

Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays

2024-12-09 Thread Yan Chengpeng
Sorry, I uploaded the wrong file. I uploaded a new patch with the modified document. Please take a review. Thanks! From: Yan Chengpeng Date: Monday, December 9, 2024 at 21:22 To: jian he , Andrew Dunstan Cc: pgsql-hack...@postgresql.org Subject: Re: [PATCH] Fix jsonb comparison for raw

Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays

2024-12-09 Thread Yan Chengpeng
If many people are already using this ‘wrong’ behavior. I agree to change the doc. I also think using ‘null’ may be a better choice. Thanks for your comments. From: jian he Date: Monday, December 9, 2024 at 16:56 To: Andrew Dunstan Cc: Yan Chengpeng , pgsql-hack...@postgresql.org Subject: Re

[PATCH] Fix jsonb comparison for raw scalar pseudo arrays

2024-11-18 Thread Yan Chengpeng
Dear PostgreSQL Hackers, Problem Description I encountered an issue with the B-Tree ordering of `jsonb` values. According to the PostgreSQL documentation[1], the ordering should follow this precedence: `Object > Array > Boolean > Number > String > Null` However, empty arrays (`[]`) are current