Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMMmC-0000Hn-Iq for pgsql-docs@arkaria.postgresql.org; Wed, 18 Sep 2013 18:47:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VMMmC-0003O3-2g for pgsql-docs@arkaria.postgresql.org; Wed, 18 Sep 2013 18:47:00 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VLr9U-00019K-Ml for pgsql-docs@postgresql.org; Tue, 17 Sep 2013 09:00:56 +0000 Received: from smtp.cesky-hosting.cz ([2a00:1ed0:2:0:1:5bef:c8ee:1]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VLr9R-0004VK-2J for pgsql-docs@postgresql.org; Tue, 17 Sep 2013 09:00:56 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp.cesky-hosting.cz (Postfix) with ESMTP id 5E9BC1765; Tue, 17 Sep 2013 11:00:49 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at smtp.cesky-hosting.cz Received: from smtp.cesky-hosting.cz ([127.0.0.1]) by localhost (smtp.cesky-hosting.cz [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id FJXcM4_QpiNi; Tue, 17 Sep 2013 11:00:49 +0200 (CEST) Received: from len.eq.cz (unknown [80.250.29.117]) (Authenticated sender: rudolf@thinline.cz) by smtp.cesky-hosting.cz (Postfix) with ESMTPSA; Tue, 17 Sep 2013 11:00:49 +0200 (CEST) Message-ID: <52381A40.9080900@eq.cz> Date: Tue, 17 Sep 2013 11:00:48 +0200 From: rudolf User-Agent: Mozilla/5.0 (X11; NetBSD amd64; rv:19.0) Gecko/20100101 Firefox/19.0 SeaMonkey/2.16 MIME-Version: 1.0 To: Dean Rasheed CC: pgsql-docs@postgresql.org Subject: Re: "format" function documentation fix References: <52341E55.5020106@eq.cz> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.6 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org (Please CC me the reply, since I'm not subscribed to the list.) Dean Rasheed wrote: > On 14 September 2013 09:29, rudolf wrote: >> The last example from >> http://www.postgresql.org/docs/9.3/static/functions-string.html#FUNCTIONS-STRING-FORMAT >> - "examples using width fields and the - flag" seems to be incorrect, see >> the attached patch. > > No, the example is correct. Referring to the documentation above that: > > If the width argument is negative, the result is left aligned (as > if the - flag had been specified) ... > > This applies even if the "-" flag is also specified. So the last > example is meant to illustrate that 2 minuses don't make a plus here. That's very unusual, IMO. This behavior follows some SQL standard or is it an invention of PostgreSQL? Thanks, r. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs