Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lXmTW-0002G3-HI for pgsql-bugs@arkaria.postgresql.org; Sat, 17 Apr 2021 15:03:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lXmTU-0004Yc-SA for pgsql-bugs@arkaria.postgresql.org; Sat, 17 Apr 2021 15:03:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lXmTU-0004YU-Iv for pgsql-bugs@lists.postgresql.org; Sat, 17 Apr 2021 15:03:08 +0000 Received: from mail-qv1-xf32.google.com ([2607:f8b0:4864:20::f32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lXmTS-0007em-4i for pgsql-bugs@lists.postgresql.org; Sat, 17 Apr 2021 15:03:07 +0000 Received: by mail-qv1-xf32.google.com with SMTP id h3so14100360qve.13 for ; Sat, 17 Apr 2021 08:03:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :thread-index:content-language; bh=G4qeT/SaRp5sb/tTAIftxe5Edsc2XGdWwnK+kqriWcE=; b=KCBYELN4T0Owt4FOM3gYjkjLxFd5JHDOr/MmlqGxDSXdljtGmTM6KtPJ/S4bXFCoVX paFLy5RsxGqABeIP57e9wJnseDq48KtOEGmV4yBmOIapehyvRvQmpdzZJBUtlsE/Oqr3 IToSOTpp9y312mffu0fOkAwLDQNSNCJtyRqI53gYPba1t0889TcsEGTMDS2lXj7nnx7x V0XgnUdXO+g/BPVBWwQyG5AUvcInItwdhSvWjXjY/Y9EAYjipvC5eu7hPnnVJx4LBFky zhzwSeYOX75ltJx9XjMD3jciSARkX+Mhe/uf1lm8QRxeYE3CmrBjztRzlZihtemfojwt RSWw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:references:in-reply-to:subject:date :message-id:mime-version:thread-index:content-language; bh=G4qeT/SaRp5sb/tTAIftxe5Edsc2XGdWwnK+kqriWcE=; b=CEZREyY5qavBK/+pnHIhLlhy28PdNZmgLQddySkEUlSNt6+mD+L38Aa/9cJiNtNoQf um0N2UYmyRf/IdWbrxPCSoCqd73RE2aam6BoTuJl1HHeJnbQwu04oKZIMM+p2k13DgZa MG3NDj81lmWvWIFGfzTf+f0Qzbv5Us9HLLNwfF862TvetxtcGoWjjTOkky0hqnjviT3f Up2YS//jZ+haIhc29XdGy1HzKq1Oara4XyQppBeiKnnqfmB7M4qElOGjt73/MxFU5kfg EM8z9XfDHNPZ7cdxSVD54rwNyogUs9LZ6wOw0IgUD47LjiKoL37IDkGgvjBhDDxE9LMX i/XA== X-Gm-Message-State: AOAM530Zmp/ELKJu8Zn0JV+YgtfmOjp+IpAO6q0e58pqL24GB+JZwV2z WPC5jLjSpxgXaOLoThjooZxtZisP1E8= X-Google-Smtp-Source: ABdhPJw/sBet4TDAsK4S2+bXWt/2pymwcA9qLXLJY7K9LriH52F0sV/tWaIAIQebaPyUs/2eI7BWuA== X-Received: by 2002:a05:6214:1906:: with SMTP id er6mr13405239qvb.38.1618671785115; Sat, 17 Apr 2021 08:03:05 -0700 (PDT) Received: from DESKTOPOL921RM ([190.183.58.215]) by smtp.gmail.com with ESMTPSA id f12sm5909042qti.63.2021.04.17.08.03.03 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 17 Apr 2021 08:03:04 -0700 (PDT) From: "Fontana Daniel C. \(Desartec S.R.L.\)" To: References: In-Reply-To: Subject: function to_char Date: Sat, 17 Apr 2021 12:03:02 -0300 Message-ID: <001b01d7339a$c42a84e0$4c7f8ea0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001C_01D73381.9EDD4CE0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Adczib2KpiWTkW9pQji12S9OtmtTVQAEPmAw Content-Language: es-ar X-Antivirus: Avast (VPS 210416-8, 16/04/2021), Outbound message X-Antivirus-Status: Clean List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_001C_01D73381.9EDD4CE0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, using postgres 12.5. The to_char function has a problem with format length. Example, select length (to_char (1, '990')) returns 4 because? if the format has length 3? -- El software de antivirus Avast ha analizado este correo electr=C3=B3nico en= busca de virus. https://www.avast.com/antivirus ------=_NextPart_000_001C_01D73381.9EDD4CE0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi, using postgr= es 12.5.

 

The to_char function has a problem with format length.

 

Examp= le, select length (to_char (1, '990'))

<= o:p> 

returns 4 because?

<= p class=3DMsoNormal> 

if the format= has length 3?

 




3D"Avast

El software de antivirus Avast ha analizado este correo electr=C3=B3nic= o en busca de virus.
www.avast.com


=
------=_NextPart_000_001C_01D73381.9EDD4CE0--