Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZUEJ3-0004uE-Hl for pgsql-docs@arkaria.postgresql.org; Tue, 25 Aug 2015 13:30:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZUEJ2-0001AR-Uz for pgsql-docs@arkaria.postgresql.org; Tue, 25 Aug 2015 13:30:28 +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 1ZUEJ2-0001AA-8s for pgsql-docs@postgresql.org; Tue, 25 Aug 2015 13:30:28 +0000 Received: from mailgate.intershop.de ([195.110.60.6]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZUEIw-0004Yx-Ph for pgsql-docs@postgresql.org; Tue, 25 Aug 2015 13:30:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=intershop.de; h= mime-version:content-transfer-encoding:content-type:content-type :content-language:accept-language:message-id:date:date:subject :subject:from:from:received; s=20130906; t=1440509417; x= 1442323818; bh=vK9H3cLKhKLuoYbM44P4isNhzmoLKZ/NySFF+3vAA1Q=; b=F BS5I4rYfB+ovXSvUU9sQYstdy5rf2Qwv/pCqAZgaYBktjiQ2JzNWI3Ug+fnCNTyv XkdAO36MetHYxRWRFW8Yy7HTYCuhCS2TB9cUx7VHURN9xOEvILl5y/eU+BlIgGEV KhcYi4RR936xrYGftk+hhwPsPjw7PR530NkflmlNMgCZhZI9Rf3MljhkP32c+lEW GlSt/rfDg6W+C4r2ZGztc0uCWMxNBbEkTshqax1EHTHmMgbcc4MrGg77miv+YtZP /iB3rzBce5MDkO0BbpeW1A6DnN7J2doec1ZfWdSNFaU2MnZVtP/H12xibu/tOipt LAnSuoqCgN0E1dmV6ynaA== X-Virus-Scanned: amavisd-new at intershop.de Received: from jenmbs02.ad.intershop.net ([10.0.87.122]) by mailgate.intershop.de (8.14.9/8.14.7) with ESMTP id t7PDUEEL002640 for ; Tue, 25 Aug 2015 15:30:17 +0200 Received: from jenmbs01.ad.intershop.net ([fe80::4d04:5c70:c5d6:d5a1]) by jenmbs02.ad.intershop.net ([fe80::1454:bb9c:d4c2:18a2%18]) with mapi id 14.03.0248.002; Tue, 25 Aug 2015 15:29:45 +0200 From: Marc Mamin To: "'pgsql-docs@postgresql.org'" Subject: unclear description for the Pattern Modifiers in formatting functions Thread-Topic: unclear description for the Pattern Modifiers in formatting functions Thread-Index: AdDfOhpZPu3J10/MQt+f08uN9VreHA== Date: Tue, 25 Aug 2015 13:29:43 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.0.56.121] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Pg-Spam-Score: -5.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 http://www.postgresql.org/docs/9.5/static/functions-formatting.html#FUNCTIO= NS-FORMATTING-DATETIMEMOD-TABLE=20 The page suggests that the pattern modifiers (e.g. 'FM') only apply for Dat= e/Time Format. But at least FM can also be used for number types: select to_char(1,'(99999)') UNION ALL select to_char(1,'(FM99999)') ----------------------------- ( 1) (1) Maybe it would be sufficient to just add FM into the table 9.24 ( http://www.postgresql.org/docs/9.5/static/functions-formatting.html#FUNCT= IONS-FORMATTING-NUMERIC-TABLE ) regards, Marc Mamin --=20 Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs