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 1l2CmG-0004Fz-Ur for pgsql-admin@arkaria.postgresql.org; Wed, 20 Jan 2021 12:40:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l2CmF-0002WO-SH for pgsql-admin@arkaria.postgresql.org; Wed, 20 Jan 2021 12:39:59 +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 1l2CmF-0002WF-In for pgsql-admin@lists.postgresql.org; Wed, 20 Jan 2021 12:39:59 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l2CmC-0004rE-Td for pgsql-admin@postgresql.org; Wed, 20 Jan 2021 12:39:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1611146392; bh=KTK+NL3WCHL0JgoVh91nbCoUKktOpxvCm0f0R/8HnAg=; h=X-UI-Sender-Class:Subject:To:References:Cc:From:Date:In-Reply-To; b=LmqWBPxPv2lOF7rlyMFcmtRocRGAtM68Ia7ZNaGXzmn5RXNQwcYqVOcoC742IUeh1 q1uH7Qxout0zptkiMbwsH5tSggSVR4frm0s+SZAAJQ1RxzuPFuq633JbkfoaLc5OQ1 1b0i/LJX3qu0PUfXJZHSEQ37fQ+VvMdfI2p8ZgFY= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.32.198] ([185.40.248.10]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1M26vL-1l0I1x0lLt-002WgI; Wed, 20 Jan 2021 13:39:52 +0100 Subject: Re: Data Type to store Leading Zero(0) To: pgsql-admin@postgresql.org References: Cc: soumik.bhattacharjee@kpn.com From: Thomas Kellerer Message-ID: <5e0bb278-b0a1-27b6-5739-c357a86334db@gmx.net> Date: Wed, 20 Jan 2021 13:39:50 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Hnk7SCCn52kh/eJ4NCwLYxc8pHBeKK9JsE7xUuitDzzifGx8QqA phABlXOwLnnjnnKp4kfH42e2QTd+uGvfW84KF0zbbMd8pdISeTj2r+0MBxtsR8igkbncaOJ eq0Mmc0M5rPUsQSvXDVyJYJRAjgXFZkQfrUat97tIJVQapfxkrg15O6zDbnTXz2hH5rcBzc 3Q8vfczeYF9uHSsI9cPyw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:Y9j9RWXdIFA=:2bKh8/g54+cG/Wc4JqHVK+ wRKhOESQgTsdZ5d+18tS446E20Lr638enA01UkuKLrxvf4natlwK2d37HEjuRB9G0CQe/GTgp TA7lfU4cifRujNgs9n3Gk+LcMB5evsI1LgUymkoLpv1HvGgzBTOHA7fx3QJ7pbyL3McpUp/zV Jhmfabkib993pE5aNu6X4GBIUoOdeHNh9Mno9jhAAFzMqYNDZbP/RANBle6eKgmcKL/+s6i8h dIMboCexIHQv5sZ1VcqrZRLHELU1PO45kZxj1g0mHafMv6fOWKKzx41aaDy7qmrCfyPJIFw8L haIs7xbmRbYJKQ1FHZeSflPPohPcxw2Vx5n1X2MRK+hTxM0YJTppK8hfl/nvRfz6rY4SzOC4x 0wSF8F9gKMGLZIbxmiklsX/I6dfopATyFwT6Xq62VSNSS17NKOsI9EVgxHEungHJUb1G3Is53 ZOZFOYgpf5qCo4tpH4WdTnqsi2C+wX8I0hiDOUCIhQ0Dk1+1LIBjWm63q2GUqLt8XGFg+ESdp vubZqzamIXzFLUSd4zB7c7YyX5tNHbU4jOepQw7sWKANDWquIimLapMvQeWBM6V7rgPQ2IgEj s8nTDT8r8MO0OOa9KNPZc0vFr5PglTh6EDIf3efCwViv06nLJAPXaPMVVpibIeMICzyEnOWYw mitAxSEX4dsPF5qwz1tz/HuMSG3oIRra39naXuXcyV2kUYxJYKO+4uXeh2XDFeD4DJ4HALZrZ 34JmjCU127HkbaLMXlGTNsYOwPwAzIQ8A1t+boFyd/QvZM5xiQM2zChuaSB8nRW6UyXrKhZN5 Li0xfq5caQu8pr9wCUF3arLD67e/yEpYc2JIuxiV8KnVkJlK9b14yWt7IwctU/iAxkj+UtRfz BnhsV3zH30bAJRiSu00Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk soumik.bhattacharjee@kpn.com schrieb am 20.01.2021 um 12:13: > As per business needs we need to store Zero(0) in primary key column > of table with this kind of value =C3=A0 07******** with applications > written in Java microservices. > > We are not able to use *numeric data type *as it trims the Zero value > in leading,**but it=E2=80=99s also aperformance impact if we define *var= char* > in the data type. While there is a performance impact between an integer and varchar, in my = experience it's rarely that big that it will become a problem. Thomas