Content-Type: multipart/alternative;
 boundary="------------m0QOy6VznTTXKXUIkvNNZ15w"
Message-ID: <49c3a0cc-2998-4e25-8bc3-e70b3cba87eb@dunslane.net>
Date: Thu, 4 Apr 2024 09:48:44 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pgsql: Add basic JSON_TABLE() functionality
To: Amit Langote <amitlangote09@gmail.com>
Cc: Amit Langote <amitlan@postgresql.org>,
 pgsql-committers@lists.postgresql.org
References: <E1rsL9y-000S60-Pn@gemulon.postgresql.org>
 <f8402aef-c66c-4207-992c-fdee5e59c612@dunslane.net>
 <CA+HiwqF8KeHyoNi8TM-fUuE_002GYANbM55ybqEWi5QRinX5YQ@mail.gmail.com>
From: Andrew Dunstan <andrew@dunslane.net>
Content-Language: en-US
Autocrypt: addr=andrew@dunslane.net; keydata=
 xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI
 gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq
 Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C
 eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys
 SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB
 AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX
 gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC
 ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY
 xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm
 HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru
 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl
 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO
 E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa
 Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo
 nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S
 GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy
 xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b
 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx
 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/
 fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4
 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0
 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS
 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw
 49QYe1sn2ZPs
In-Reply-To: 
 <CA+HiwqF8KeHyoNi8TM-fUuE_002GYANbM55ybqEWi5QRinX5YQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/49c3a0cc-2998-4e25-8bc3-e70b3cba87eb%40dunslane.net>
Precedence: bulk

This is a multi-part message in MIME format.
--------------m0QOy6VznTTXKXUIkvNNZ15w
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit


On 2024-04-04 Th 09:20, Amit Langote wrote:
> Hi Andrew,
>
> On Thu, Apr 4, 2024 at 10:06 PM Andrew Dunstan<andrew@dunslane.net>  wrote:
>> On 2024-04-04 Th 07:21, Amit Langote wrote:
>>
>> Add basic JSON_TABLE() functionality
>>
>>
>> Excellent!
>>
>> But I am getting this:
>>
>> ../../../src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc:23: WARNING: unsupported feature will be passed to server
>>
>> Is that intended?
> I don't get that WARNING here, but I remember seeing it at one point,
> which I am supposed to have fixed.
>
> Can you please share more details about where you're seeing it?


It's with a meson build:


[2330/2355] 
/home/andrew/pgl/pg_head/root/HEAD/pgsql.build/src/interfaces/ecpg/preproc/ecpg 
--regression -I../../../src/interfaces/ecpg/test/sql 
-I../../../src/interfaces/ecpg/
include/ -o src/interfaces/ecpg/test/sql/sqljson_jsontable.c 
../../../src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc
../../../src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc:23: WARNING: 
unsupported feature will be passed to server


cheers


andrew

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

--------------m0QOy6VznTTXKXUIkvNNZ15w
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 2024-04-04 Th 09:20, Amit Langote
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+HiwqF8KeHyoNi8TM-fUuE_002GYANbM55ybqEWi5QRinX5YQ@mail.gmail.com">
      <pre class="moz-quote-pre" wrap="">Hi Andrew,

On Thu, Apr 4, 2024 at 10:06 PM Andrew Dunstan <a class="moz-txt-link-rfc2396E" href="mailto:andrew@dunslane.net">&lt;andrew@dunslane.net&gt;</a> wrote:
</pre>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">On 2024-04-04 Th 07:21, Amit Langote wrote:

Add basic JSON_TABLE() functionality


Excellent!

But I am getting this:

../../../src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc:23: WARNING: unsupported feature will be passed to server

Is that intended?
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
I don't get that WARNING here, but I remember seeing it at one point,
which I am supposed to have fixed.

Can you please share more details about where you're seeing it?</pre>
    </blockquote>
    <p><br>
    </p>
    <p>It's with a meson build:</p>
    <p><br>
    </p>
    <p>[2330/2355]
/home/andrew/pgl/pg_head/root/HEAD/pgsql.build/src/interfaces/ecpg/preproc/ecpg
      --regression -I../../../src/interfaces/ecpg/test/sql
      -I../../../src/interfaces/ecpg/<br>
      include/ -o src/interfaces/ecpg/test/sql/sqljson_jsontable.c
      ../../../src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc<br>
      ../../../src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc:23:
      WARNING: unsupported feature will be passed to server<br>
    </p>
    <p><br>
    </p>
    <p>cheers</p>
    <p><br>
    </p>
    <p>andrew<br>
    </p>
    <p><span style="white-space: pre-wrap">
</span></p>
    <pre class="moz-signature"
    signature-switch-id="d0437855-2267-4610-80b3-83167ec45b0b" cols="72">--
Andrew Dunstan
EDB: <a class="moz-txt-link-freetext" href="https://www.enterprisedb.com">https://www.enterprisedb.com</a>
</pre>
  </body>
</html>

--------------m0QOy6VznTTXKXUIkvNNZ15w--