Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZrkyH-0008Mu-I7 for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Oct 2015 11:02:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZrkyH-0005iL-3u for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Oct 2015 11:02:17 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZrkyG-0005i9-Az for pgsql-hackers@postgresql.org; Thu, 29 Oct 2015 11:02:16 +0000 Received: from mail-wi0-x234.google.com ([2a00:1450:400c:c05::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zrky9-0001dN-Tt for pgsql-hackers@postgresql.org; Thu, 29 Oct 2015 11:02:15 +0000 Received: by wicfx6 with SMTP id fx6so224008806wic.1 for ; Thu, 29 Oct 2015 04:02:07 -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=1Z11kqgIcgt1KFwhhZlpTRbUr/jt1xlSLd5wHJkBLoo=; b=ZGL/I/6cHWuG+VdYOzMw3xpHtCxPf+z4XegSVMDgbdrEGxIFI8cqOBFoBPerQlQlaB lrPNJ+EMVk0TUju8sDaB/rWhS9/r2kZVK1y5RE1Fdg3sM/2DcK53aJe7cCxfVlY0eYbY 4JJTCE/FsUZqjmKOvnSHN8vBeFsocI2gVRM2uvcGcYJ9SR2+EwCEgJaoEg+0vEqAvTp7 peKZNrWYvAqGlgf8DEdFJTrnhXzXKVqICzbErBCqpeZwV/aq+zsgijAbRYykO/YQXqY7 K3ZczYwy4aPwZEEFKgTKaLvEfsWOjBySs1BOmSDOFYN4FPXo5asZqZwcrwWUXKroUdnz kVhw== 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=1Z11kqgIcgt1KFwhhZlpTRbUr/jt1xlSLd5wHJkBLoo=; b=NRUoW2NII9faYGFWYXG7DU8MtvWjbB6zfgPlNaXMbzA1cR0OOjp5lewzeZf45slBNv dPcWvEZMmr+W8wHCzUTp2vwbvdYHwD726WINuHSdMe1wDORShhqkNMJ9akDKHDr6bYzu xRFlDTJbLhQ1NS27fAvyul/nBmcmrL5FAMF/ExP4CMg/+hly3YauFRsVikE+/FNuSY6n OQZmilo48gas6oeAoYfE7uFxtEKtCGD651wTpDpIV1BdGE/Qpggba08QT7ZiXnV2NWpp c8krFe9MGT/nCQ2C8L+FqsD8I3O85QInicWVFHt464Y2rCTEiTp38RJ93Xv1skDm7HCY 7Lww== X-Gm-Message-State: ALoCoQk5waRR8vjNt3u8Xg79bqZJlpOHCVk+ZJwohxhkbhT5wKQNgsWDJu1RvW3vMTHKLsVy+n07 X-Received: by 10.194.184.207 with SMTP id ew15mr1318269wjc.99.1446116527373; Thu, 29 Oct 2015 04:02:07 -0700 (PDT) Received: from Markos-MacBook-Pro.local ([213.164.8.43]) by smtp.googlemail.com with ESMTPSA id e79sm8626135wmd.16.2015.10.29.04.02.06 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 29 Oct 2015 04:02:06 -0700 (PDT) Subject: Re: psql: add \pset true/false To: Daniel Verite References: <0949c317-3ec4-4516-a3aa-33a6cfbf5267@mm> Cc: PostgreSQL hackers From: Marko Tiikkaja Message-ID: <5631FCAF.9060204@joh.to> Date: Thu, 29 Oct 2015 12:02:07 +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: <0949c317-3ec4-4516-a3aa-33a6cfbf5267@mm> Content-Type: text/plain; charset=iso-8859-15; 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/29/15 11:51 AM, Daniel Verite wrote: > Marko Tiikkaja wrote: > >> Since the default t/f output for booleans is not very user friendly, >> attached is a patch which enables you to do for example the following: > > Personally I think it would be worth having, but how about > booleans inside ROW() or composite types ? There's not enough information sent over to do that in the client. Note that this works the same way as \pset null with SELECT ROW(NULL), so I don't consider it a show stopper for the patch. .m -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers