Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdzc3-005Q0K-UU for pgsql-docs@arkaria.postgresql.org; Wed, 06 Sep 2023 20:59:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qdzc2-00DEKZ-Ix for pgsql-docs@arkaria.postgresql.org; Wed, 06 Sep 2023 20:58:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdzc2-00DEKP-7p for pgsql-docs@lists.postgresql.org; Wed, 06 Sep 2023 20:58:58 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qdzbx-003ULa-O2 for pgsql-docs@lists.postgresql.org; Wed, 06 Sep 2023 20:58:57 +0000 Received: by mail-ed1-x535.google.com with SMTP id 4fb4d7f45d1cf-51a52a7d859so2987792a12.0 for ; Wed, 06 Sep 2023 13:58:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1694033931; x=1694638731; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=bUGu9eQXRXp/vqmINSshAHZ6hAdU97ebLG+gxf1VzHo=; b=LMQyo9PsHYS3BAA4MAQkd8BINa2JVtbL6aje4F8YoAsYJnbaQ2ZgIsXZWQp/fMICjl vj6NpwzcoXi8WsGCSRGBdpvDIOA6NafogSHUEv4xBmc8cAu+F47Ye4czpPQIYZHqYm30 mw3+WbVKcyG7EcRQIyPG5si62jjHByIekI1erSgkObY0UgUX0hZxv2muItezCvANkuHN m0Kp+Me9PmJWOGy9r8Pk3Noh8xdmU0c26UdHWDB5Iro+bEmQsKQP/s84RXJVDBSfbZjk Udo4bOekPoHhYxZk5Mpdtbg2eE35nvP7I+NvwF8qiv/OOmyDSjU491e0Wp7ggceG3wv7 XsnA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1694033931; x=1694638731; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=bUGu9eQXRXp/vqmINSshAHZ6hAdU97ebLG+gxf1VzHo=; b=ADqn/YnFQ7QE9/Wj/mgUhOCZjgcmYPXhbBQRvs8dLBVWYhi0P0OIGZvRw9M6MoozJ/ XOkp7LP7mnVEu/yI++WqmVTqWp4LOJaQ/jR5B39G4nh/tLL/MHQMbIGVWiHeajRYq4wY INQ5CjRnIbEYr3IusUOpIfucm7yN5C3uY4GHYmJ+zpLO9sUVXsTT6Hnh6dSIVyaZF2MA mLLJ7UQYoGwKqp/xdBhOVFiczflsRRjKKVFTsG/4ua1cRnIQFYX7Vd3afstTFlqDm6GK XRzDyalISgEmXJh97D348ulVCFhXBUKGbTxI6D594FmSxRQc4w+s0XXS/VC5hJ3Pwe+I BNYA== X-Gm-Message-State: AOJu0YyCWwtsuD8r8bZAXQRaRyNi63/vF0d4pnU6GZW1zCtdSbeYTUlU aIZLgct3RVoLaVbw2IVbDTlYPQ== X-Google-Smtp-Source: AGHT+IHH2F22ay66UM9ZDUILdO+YmT4ouJsQ+dNmYeX2DzqbUFp2+YMec8jvwQPFFsVMNfH55Chpjw== X-Received: by 2002:a05:6402:349:b0:522:18b6:c01f with SMTP id r9-20020a056402034900b0052218b6c01fmr1078837edw.3.1694033931601; Wed, 06 Sep 2023 13:58:51 -0700 (PDT) Received: from localhost.localdomain (62-46-253-73.adsl.highway.telekom.at. [62.46.253.73]) by smtp.gmail.com with ESMTPSA id t11-20020a05640203cb00b0052a1d98618bsm8979521edw.54.2023.09.06.13.58.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 06 Sep 2023 13:58:51 -0700 (PDT) Message-ID: <2ddc9313a5ac1833aa56dc031d1f42e478ee764e.camel@cybertec.at> Subject: Re: to_char(numeric type, text) rounding instead of truncating From: Laurenz Albe To: Bruce Momjian Cc: barsikdacat@gmail.com, pgsql-docs@lists.postgresql.org Date: Wed, 06 Sep 2023 22:58:50 +0200 In-Reply-To: References: <168991536429.626.9957835774751337210@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-09-06 at 16:53 -0400, Bruce Momjian wrote: > I slightly modified your patch and applied it back to PG 11 since all > supported Postgres versions have the same behavior.=C2=A0 Thanks. Thanks for picking it up. Yours, Laurenz Albe