Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsMnH-006b3a-6m for pgsql-committers@arkaria.postgresql.org; Thu, 04 Apr 2024 13:06:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rsMnG-004x3P-Bk for pgsql-committers@arkaria.postgresql.org; Thu, 04 Apr 2024 13:06:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rsMnG-004x2c-1O for pgsql-committers@lists.postgresql.org; Thu, 04 Apr 2024 13:06:14 +0000 Received: from mail-oi1-x229.google.com ([2607:f8b0:4864:20::229]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rsMnB-000bWL-Hw for pgsql-committers@lists.postgresql.org; Thu, 04 Apr 2024 13:06:13 +0000 Received: by mail-oi1-x229.google.com with SMTP id 5614622812f47-3bd4e6a7cb0so392558b6e.3 for ; Thu, 04 Apr 2024 06:06:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1712235967; x=1712840767; darn=lists.postgresql.org; h=in-reply-to:autocrypt:content-language:from:references:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=R598CRYg/Cm3bJS+11tM/bNnkvvsALvNdyKZXRBnOdo=; b=nv3T6NOjF5HkpsPK25IgdOvWd3C+mcERgxzauuMUQZcjUV5tZrrz49xmdbG2PpIQsY PGW+hBRbE8bp7LTyzwrhOp8XazTudEngobjSgql2XOZp5Z7+ZTfoFqMvPa3Ww5qQTbUF JKANOTYfJmsUZOeNXf4jFilsmuKMsve8AFBHJT2efVp/R/2GrpKHi6+8Azx0Oxqmmt3u LGKsY/SNm6lU3UJCLe4JcsTSeGl4ghFIlwSCo8m5HJEtBTkB7NNAr9If0ABJHzSts4H8 VjSrGysGPch3YoT5l6Gg6NlT1+QX+Tm+PZ4Rrf0yIIHa6j7pfn4mvhYAUEH7E4QBVQjU 58sQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712235967; x=1712840767; h=in-reply-to:autocrypt:content-language:from:references:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=R598CRYg/Cm3bJS+11tM/bNnkvvsALvNdyKZXRBnOdo=; b=HT2XvHYqK55VN6XYp2uONt4IJw+CWeP1tgPp1oIYzS3kOSWJXdQcA7xCjP2FMjQwaj LuB6FVrcA7gz75rpTkElH82U2Muk64bXFWwc1PSmkzGDRrVsI5VqBILF4UWdRIteZaiE 7t5MVni/RlzW12NoIWb/M2mPHfXJY+BM2W4/SbyCko4/3X1O78WxKntepg/hpFi86QoY Kj2B7Sg+zuVSgrdmsshnsu8+Bjby2vN4YuvmvCUt+OTr18xS7NZzfMB3TvZAVS1miupG lEhkKsQSGgZXStPqDeTrSle2xjNIpghWllRSs009nys2irfme+turrsyKhk2lXPtB4qJ dA7Q== X-Forwarded-Encrypted: i=1; AJvYcCWt7fDZsjrKvC09cF3q6WOH8w3Vy/wcCy4debaASVHpbuj3/nvkDZnMPJZoMAn0pBEjabUoh1V8amIpzZaQD84Qtq4VfdaWiennDvr6RC83f+4N+kBB X-Gm-Message-State: AOJu0Yx5CS31qt4g6MKcCceGo4W8N2+40gZcRyVEGqTX4+vJWnNaOEbQ 2ilhhjrjUa/FIHoP31eSnRQUayEPYlGQWbf3ljbIJH3bgY8w1Vs6dmLuSVW6UbU9MlCTIjeICAI 6 X-Google-Smtp-Source: AGHT+IG1C8IWRZr74AMevY5lEqFP43K8FXzvdG6eaJ+mxHtGYrzZLQTKUK30KVJXzIlfqwAwz4ifXw== X-Received: by 2002:a05:6808:1385:b0:3c3:a000:50e3 with SMTP id c5-20020a056808138500b003c3a00050e3mr2818503oiw.37.1712235967409; Thu, 04 Apr 2024 06:06:07 -0700 (PDT) Received: from ?IPV6:2605:a601:9180:9800::2bb? ([2605:a601:9180:9800::2bb]) by smtp.googlemail.com with ESMTPSA id et16-20020a05622a4b1000b00430b385f721sm7594530qtb.15.2024.04.04.06.06.06 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 04 Apr 2024 06:06:07 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------1WeBbxmL9Ot8mqx8NWbS0Zxg" Message-ID: Date: Thu, 4 Apr 2024 09:06:06 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgsql: Add basic JSON_TABLE() functionality To: Amit Langote , pgsql-committers@lists.postgresql.org References: From: Andrew Dunstan 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: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1WeBbxmL9Ot8mqx8NWbS0Zxg Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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? cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------1WeBbxmL9Ot8mqx8NWbS0Zxg Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit


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?


cheers


andrew

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