Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gDAvE-0006T8-CD for pgsql-admin@arkaria.postgresql.org; Thu, 18 Oct 2018 16:13:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gDAvB-0001TV-MC for pgsql-admin@arkaria.postgresql.org; Thu, 18 Oct 2018 16:13:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gDAvB-0001TN-9y for pgsql-admin@lists.postgresql.org; Thu, 18 Oct 2018 16:13:13 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gDAv8-0004d0-JG for pgsql-admin@lists.postgresql.org; Thu, 18 Oct 2018 16:13:12 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id B677E22A85; Thu, 18 Oct 2018 12:13:09 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Thu, 18 Oct 2018 12:13:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=O8VACsiQZRo3VY8xz9DUjuDiLFu MASGDA7ZIf84cn0A=; b=PT49CF4e13Q0zaQlkq2fKLx0uvJ7uAB3YzIWzkJNBNc YgXv1w27FunFy/De64DYyRVCA/Z/1k/H4LMleKEsrfp2EC6G6X6U8LO8r0mxieJN 8U3pjeEejAbYs2qJIcwCfRqh3NVSvKnIOqm9V8dTHJU6Xqly2CBjYfyfaiaK9/X5 fHJBJ8SWYh9oARxk+5+M9zYDitFo7GLFy5mT4Lx9zJ8MDjvMwXogFvNM7FqTPi8b znUkUelfXOGyC48hdNo3w1Bv603pM4RD6o7iG0UUTaIXXr17c0qu84JkPi1aU+T4 +Ai1qoVreU6FkQB5VjyNcrptp+T91fCaq4jIcCGfRgg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=O8VACs iQZRo3VY8xz9DUjuDiLFuMASGDA7ZIf84cn0A=; b=WVWto1DDtgkZH9sEW2bNXg R9rixVUPxmxKD4HL/cz3MrC2fNpuG400oIPvWZJKPD8ePRRQbGhDK7AnzC79+yBG HPBqz/S0LQcLnlFYUxqi2gNcAmkEpGUmgWi2p/3g8qIbbCFK84bvEkAeHyqWsAHa 2FP85QgfiQiKQAIqGf/pUS4gqTvksXUGJ80JdSz2XqJNMCGT6BxsCgBdxPCyNNC+ ksTl7kxhbDOYYqC7+FgstlpTy/I9SFmoS+RiXmvJckNm+2CgHnolfadO/LQ9iSpz viEMzUWchQ2PGs5o469LGyDRdBfk6VShd2xrA3mX6Uc3b3B+nedzWy0VzsT+8Vag == X-ME-Sender: X-ME-Proxy: Received: from intern.anarazel.de (c-98-210-140-171.hsd1.ca.comcast.net [98.210.140.171]) by mail.messagingengine.com (Postfix) with ESMTPA id 29FB4102A0; Thu, 18 Oct 2018 12:13:09 -0400 (EDT) Date: Thu, 18 Oct 2018 09:13:07 -0700 From: Andres Freund To: Marcus Strube Cc: pgsql-admin@lists.postgresql.org Subject: Re: "constructor" does not work as alias for me Message-ID: <20181018161306.332owvtzgjkch7ps@alap3.anarazel.de> References: <20181018160221.k42wo2lj6jsqgq4m@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, (please don't top-quote on these lists, thanks!) On 2018-10-18 18:07:51 +0200, Marcus Strube wrote: > On Thu, 18 Oct 2018 at 18:02, Andres Freund wrote: > > On 2018-10-18 17:44:21 +0200, Marcus Strube wrote: > > > the alias "constructor" does seem to be a problem. > > > > > > select n as "constructor" from (VALUES (1), (2), (3)) AS t (n) > > > > > > This gives this result: https://imgur.com/a/dM9eM06 > > > > > > psql for both gives the same result. > > > > > > I am running the latest version from the "PostgreSQL Apt Repository" on > > > Ubuntu 18.10 in desktop mode. > > > > Could you verify that the same happens when you use psql? > No, it doesn't. > > In psql > > select n as "constructor" from (VALUES (1), (2), (3)) AS t (n); > select n from (VALUES (1), (2), (3)) AS t (n); > > both give the same result: https://imgur.com/a/x0XkvwB Hm, so that seems like GUI problem. Which you probably best direct at whatever GUI that is (sorry, I don't use any, so I can't identify it). - Andres