Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zrb95-0007Mj-As for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Oct 2015 00:32:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zrb94-000490-Dy for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Oct 2015 00:32:46 +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_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zrb91-00048B-Ui for pgsql-hackers@postgresql.org; Thu, 29 Oct 2015 00:32:44 +0000 Received: from mail-wi0-x22d.google.com ([2a00:1450:400c:c05::22d]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zrb8y-0000Zu-D3 for pgsql-hackers@postgresql.org; Thu, 29 Oct 2015 00:32:42 +0000 Received: by wikq8 with SMTP id q8so270667767wik.1 for ; Wed, 28 Oct 2015 17:32:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joh_to.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-type:content-transfer-encoding; bh=tnpAaGAhcfAasiL/Y+x863exU5fXMduhkQJpgqv5npo=; b=FuhQsNXgfeFXDBkFJR6R98+hXUX05qjapJ5bgH9PCCQT3tf/nn6prtoUG6wOGpkWN3 UhjkPaMFwu7u32hYz79tmnOTcz7orMkSsiOWvVkuqYTd0Gx6zkUWB8XJdRbusmNGzgzj v9YUMgjbbF5/cY1kp4eFrL1o/aS9WC1eoVA+yRyl/ys2SXxTGGvUm+XS5GhloaejqnKa mt/hbLb0Cm9O1IGhKlL+582o6K/OLEIHULaaG96n5JHqviUbyUlR5NlSIRNwqjQQkn3e RtvQQQB0TbTlF6hAex2Ft/WbiuIhz2Uz8g8GN7+L+ugq5tktxEtXm9MyqeNla++OUMmd gG0w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-type :content-transfer-encoding; bh=tnpAaGAhcfAasiL/Y+x863exU5fXMduhkQJpgqv5npo=; b=jMCemiCHB6iAwfRcFZGveoshgB8QqhPoV5bPiXQfMhSFuqZUtzvu578/E/ybj1UKcE gDEvmQ66ZN33TTYw+JqfG9M4GPzRxBO4rXay2VCtGEvjU5wkb5rx8V6mbj/TB4qQhCAm tz0pSZtX2m1lJ7DBdwT4cJBtKiqLXA5Uu0Nf05o7SZ80tHQyUu9aLlCyou44uBzOzoQu MKYmCP9EmCUMPKT9Ce0Ockp2B2INdquQYVK7xzT7wjTYWqpJaTCQUPFohHEuvBukx7Dw R1B19GeJJAmoGNVyIIQOk3LH6IWUNtsa3TG3d4PfUYEf3CeT8yjP0da0d13vg/KcBqaH vwaQ== X-Gm-Message-State: ALoCoQmMfv1SHldEplpyRGTjp9B4Qja7ltKV676lA80PhAOd+BkdBo+kpoFgRdSawDzg9pDFl6sq X-Received: by 10.195.11.98 with SMTP id eh2mr35318305wjd.59.1446078758602; Wed, 28 Oct 2015 17:32:38 -0700 (PDT) Received: from Markos-MacBook-Pro.local ([213.164.8.43]) by smtp.googlemail.com with ESMTPSA id 199sm6405678wml.22.2015.10.28.17.32.37 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 28 Oct 2015 17:32:38 -0700 (PDT) Subject: Re: psql: add \pset true/false To: Robert Haas References: <56308F56.8060908@joh.to> Cc: PostgreSQL hackers From: Marko Tiikkaja Message-ID: <56316925.4030307@joh.to> Date: Thu, 29 Oct 2015 01:32:37 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 10/28/15 11:52 PM, Robert Haas wrote: > -0 on this concept from me. I'm not going to vigorously oppose it, but: > > 1. You can always do it in the query if you really want it. True, but not always practical. > 2. If you're the sort of person liable to be confused by t/f, you > probably aren't in the target audience for psql anyway. Really? The difference between t/f is that the vertical squiggle is flipped, THAT'S IT. Consider: t t f f f f t f t f Saying that I'm not target audience for not being able to see WTF is going on above I find offending. > 3. I really don't want to end up with a bunch of features of this type > for a variety of different data types. Fine. Then let's not add it for a different variety of data types. But boolean is quite essential and it has a really small number of valid output values. .m -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers