Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i5HGg-0005Pc-Qo for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Sep 2019 22:27:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i5HGf-0003Lc-LZ for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Sep 2019 22:27:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i5HGf-0003LV-DP for pgsql-hackers@lists.postgresql.org; Tue, 03 Sep 2019 22:27:17 +0000 Received: from mail-qk1-x741.google.com ([2607:f8b0:4864:20::741]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i5HGc-0002z0-Q6 for pgsql-hackers@postgresql.org; Tue, 03 Sep 2019 22:27:17 +0000 Received: by mail-qk1-x741.google.com with SMTP id f10so17731972qkg.7 for ; Tue, 03 Sep 2019 15:27:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=WDi4ANpPRO/lk+9+BoPfBDhnFyXUTGVCsX3TgdISZ/k=; b=zzEtEGJL+ma/osDPGAb0/HglFKrUm8xRUaSMp7dzmPtyYzrh6wiholOvMDdCO5YOqL ktziXyio96fYss0w/mBRTEdea1mq7UCfDXIu7EDqRx+zvyaLLGG0a/oSJjNAjVCAxjRm HeTjOqcmL33ZckAa4AhI5FPx61vc+ioIcB0lSAcFaTs6d7434ImCfoZvkhYf+4/pPLtF t1kqc2drv5D7gbzxMkHfhK5p/yEeviiRTzP7PTEmD6s/GGyPf1k9Lr8NKjm455UZM86F 0OMOaBFO4S8LeitKzqVjmcN0beyGMA58U2m2qEJczC5XJE+t5eMq8zaT1EDhE63Q2jAd gmvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=WDi4ANpPRO/lk+9+BoPfBDhnFyXUTGVCsX3TgdISZ/k=; b=RwZzAt0c524zU19QYhr44KEltRSRO63+8IxDclfHDIJIq4RtoaeYceljFkwwTJ6/0s OJWWs3IWJGTVAsCdloLbhfGsHK1YQosExm+620Q6r9uz5PMwjX/Co6GIxt12QleVBi2t 850E9E10ZjLHALaK48Iukm2yzKmBAi7GRSXVVkJUaRmE4oMYRLnq9DcxQfK+0njnVX23 dCrZQgAwX2rhksqrRWEJRbcjAkYcCwq9JypAjtuhKBeplcY+srkvRSUuWueZsq8ytOR/ 3aIq27s4MJ0GyJqWg5SZeWqb4OZ/upAvf860utMJt756eo4meYGtgXefTr4HOebfUql3 IfJw== X-Gm-Message-State: APjAAAUcrPuNLsxJU7BxNj+cKuBk2KUyZTrVJDjENYn69DjlnGQ4ysth 2hGeFNJQu4ErTAKcA6osnXpAOw== X-Google-Smtp-Source: APXvYqw11HVfCTW2IX4PqIh5hFoy/4kU3kQYlBfMhcOKri/zYe79CdBuX3uUjVVlPGJBaqwWLsU3nQ== X-Received: by 2002:a37:6813:: with SMTP id d19mr36476470qkc.101.1567549633532; Tue, 03 Sep 2019 15:27:13 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id p77sm7386063qke.6.2019.09.03.15.27.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 03 Sep 2019 15:27:13 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 7E06B120E47; Tue, 3 Sep 2019 18:27:11 -0400 (-04) Date: Tue, 3 Sep 2019 18:27:11 -0400 From: Alvaro Herrera To: Nikita Glukhov Cc: Thomas Munro , Andrew Alsup , PostgreSQL-development , Andres Freund , Dmitry Dolgov <9erthalion6@gmail.com>, Pavel Stehule , Oleg Bartunov , Alexander Korotkov , Michael Paquier , Simon Riggs , Andrew Dunstan Subject: Re: SQL/JSON: functions Message-ID: <20190903222711.GA13831@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Jul-16, Nikita Glukhov wrote: > Attached 37th version of the patches rebased onto current master. > > Preliminary patch #1 contains: >  - implementation of jsonpath .datetime() method (see [1]) >  - jsonpath support for json type (should be posted later in a separate > thread) 0001 doesn't apply anymore. Can you please rebase? (Only now I realize that this SQL/JSON stuff has its own commitfest entry, separate from the JSON_TABLE one.) Thanks, -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services