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 1ioSlM-0003Y2-Nb for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jan 2020 13:49:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ioSlJ-0003S1-Br for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jan 2020 13:49:41 +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 1ioSlI-0003Rt-UO for pgsql-hackers@lists.postgresql.org; Mon, 06 Jan 2020 13:49:41 +0000 Received: from mail-wm1-x341.google.com ([2a00:1450:4864:20::341]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ioSlF-0003j3-4D for pgsql-hackers@lists.postgresql.org; Mon, 06 Jan 2020 13:49:40 +0000 Received: by mail-wm1-x341.google.com with SMTP id p17so15340924wma.1 for ; Mon, 06 Jan 2020 05:49:36 -0800 (PST) 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:references:mime-version :content-disposition:in-reply-to; bh=Fr7r/GWpeHpjtENuqxz/OB7Rt8kCeRtsRUz2V9F0aqY=; b=d613BjVVE4NqsH1vJmnWhu241Jkd3VvMGOSe45kq5y2bhH8p8QB/D3b5y5T3VRuEsz VF9IlbMi+dL9+WeWUkKWWlsLkJHSI/VMTWU7A5XnFWLe6zIirLua/4QofcwkqseuIx26 4B3FgOt3MkPiT8GzegXNQ0WfP3gJHIHZ5oBxWDmmvr9CpCQdi94PmnYuhxKgMnQ7mknw sYVM+gwmljLoP6RBaCkF6UPvjDQXr4aghInGeTcnQPx1BJlzBNPo5x0nqoqmp3jsHEKC FGlgaL/e/AMaETt66wBMSwMrg5WlKOTmx+mGBVZkWmSuXkQuB4S68BxuO/wTpuzGyihc xLqQ== 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:references :mime-version:content-disposition:in-reply-to; bh=Fr7r/GWpeHpjtENuqxz/OB7Rt8kCeRtsRUz2V9F0aqY=; b=KviOgL/9jc7hGc1SSNNyKg0nqXKP3mw+XVkwGIZ6UiokWArnAMZSx5dRx3bOtRY9lc uhHKH3QJy9IYLz9fvi1/6WKEZVOek/7ibC0c+/rXsACInFIHKAALGs9+zpOQwy9GstQB HQoAUSf0G9cdjC2Ej1RktFdHtzGaJyJrbGc4lNMoyU3j5OyEo/oIAoQTZfW2uz9NarCg BlPYcQ03Geqj/z9QCXSumYwbZrUrLYhZCN2X0TkJWwaWfFWTsOIUHb2F92pSEmONwz4v agbBoIjyVo1nWyDvomXhWf8tTpvEWXwVezTwcnO9RfXjDXNpE/+IE/9+qrjMdLQnfEji 3LMw== X-Gm-Message-State: APjAAAXeeXkPHALhsMn08W8axqzfqNcRuH7iDvXgZmz/MZu5SoGVlhs9 j0v0s7Yxmes576dMnMEmx0LM9w== X-Google-Smtp-Source: APXvYqwwp0ftG8BnLGCgkaS/z16bG1bahKy+7wCEeFRwXhAv9f6jvtWtrVjbhSqaQPMH8t6CsjygMQ== X-Received: by 2002:a1c:7ed0:: with SMTP id z199mr34097960wmc.58.1578318576070; Mon, 06 Jan 2020 05:49:36 -0800 (PST) Received: from localhost (ip-86-49-253-92.net.upcbroadband.cz. [86.49.253.92]) by smtp.gmail.com with ESMTPSA id f207sm24817626wme.9.2020.01.06.05.49.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Jan 2020 05:49:34 -0800 (PST) Date: Mon, 6 Jan 2020 14:49:33 +0100 From: Tomas Vondra To: Thomas Munro Cc: Nikita Glukhov , Dmitry Belyavsky , PostgreSQL Hackers , Alvaro Herrera , Nikolay Shaplov Subject: Re: Ltree syntax improvement Message-ID: <20200106134933.u2rblkj7ec4jky6u@development> References: <20190708203303.GA17993@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, This patch got mostly ignored since 2019-07 commitfest :-( The latest patch (sent by Nikita) does not apply because of a minor conflict in contrib/ltree/ltxtquery_io.c. I see the patch removes a small bit of ltree_plpython tests which would otherwise fail (with the "I don't know plpython" justification). Why not to instead update the tests to accept the new output? Or is it really the case that the case that we no longer need those tests? The patch also reworks some parts from "if" to "switch" statements. I agree switch statements are more readable, but maybe we should do this in two steps - first adopting the "switch" without changing the logic, and then making changes. But maybe that's an overkill. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services