Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VNAS5-0005uJ-RJ for pgsql-docs@arkaria.postgresql.org; Fri, 20 Sep 2013 23:49:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VNAS4-0004rC-LW for pgsql-docs@arkaria.postgresql.org; Fri, 20 Sep 2013 23:49:32 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMviD-0006vX-6y for pgsql-docs@postgresql.org; Fri, 20 Sep 2013 08:05:13 +0000 Received: from smtp.cesky-hosting.cz ([91.239.200.238]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMvi9-0005jW-NR for pgsql-docs@postgresql.org; Fri, 20 Sep 2013 08:05:12 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp.cesky-hosting.cz (Postfix) with ESMTP id 0032B2908; Fri, 20 Sep 2013 10:05:07 +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 LUL3Rpxl2CjL; Fri, 20 Sep 2013 10:05:06 +0200 (CEST) Received: from len.eq.cz (dsl-d05pool-182.cust.termsnet.cz [217.194.163.182]) (Authenticated sender: rudolf@thinline.cz) by smtp.cesky-hosting.cz (Postfix) with ESMTPSA; Fri, 20 Sep 2013 10:05:06 +0200 (CEST) Message-ID: <523C01AE.5020306@eq.cz> Date: Fri, 20 Sep 2013 10:05:02 +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: Pavel Stehule CC: Dean Rasheed , pgsql-docs Subject: Re: "format" function documentation fix References: <52341E55.5020106@eq.cz> <52381A40.9080900@eq.cz> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.8 (/) 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.) Pavel Stehule wrote: > 2013/9/17 rudolf > Dean Rasheed wrote: [...] > 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? > > this is postgresql feature - standard doesn't support any similar > functionality - and printf is some like developer Esperanto. We > significantly reduced complexity of printf function and we modified > basic rules for usage in SQL, but some very typical rules - like format > placeholders, we share - we don't introduce own rules there. Yes, as I already wrote to Dean (and forgot to cc the list), you are right, the behavior is correct. Thanks for the explanation! Kind regards, r. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs