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 1tVOHD-007uEo-MO for pgsql-general@arkaria.postgresql.org; Wed, 08 Jan 2025 05:06:44 +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 1tVOHB-00Chmr-S3 for pgsql-general@arkaria.postgresql.org; Wed, 08 Jan 2025 05:06:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVOHB-00Chmi-H5 for pgsql-general@lists.postgresql.org; Wed, 08 Jan 2025 05:06:41 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tVOH9-000S8A-0i for pgsql-general@lists.postgresql.org; Wed, 08 Jan 2025 05:06:40 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-e398484b60bso20995661276.1 for ; Tue, 07 Jan 2025 21:06:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736312799; x=1736917599; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=GgJ3h4V1QNVozE9ARrp1zBykPLx76HDAvMvh2zWzvGk=; b=goxhYNf0oxrNt5ait1vCX7trguYGN4BfpHutao+61uNKUxhfYF5RCdQUhAr+mlXCKD 8bPNGdbzEr0iMsiSnHDKdVERhrHUbZN8jVT6r61yCqV8OmtzKQxOVhxF+f5tc+FciCtU /rYIDjEYvNCuufofB3oPORJuBQMLaBLlR29lW92wTzA7afZMcv7NvCoVr4l6/0pLpXi9 4wjiMEMdEZccG1jlXeDlf7jGdNGw1MxnEcqbbLM1NkVF0bXLqf3HzEDiHhCxk/XINDE3 RZujZImc//O5hzDhV324SgOpP3W7allL//tLlNaG8dBtR7nEBKglZmP3/vl4ACA+Rs4X REdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736312799; x=1736917599; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=GgJ3h4V1QNVozE9ARrp1zBykPLx76HDAvMvh2zWzvGk=; b=JU2Ab0oPPScY2AaKOnzg1myolf/T/JhGwYiRTc8UpiX0EsF4Ca911x/lTgpoB62QPL YZN4SGSKBhilYoUyw6Y+lAO8/wtEMmbAHv5Y4sS8X+oi+9zlD0UxXpNvtGSAIsA5zbkZ 2Pg94TQDR5uQICSfsttwu5uSGHDFZ/3VZ8yMWKU9mk6DMJ7uwHHhQZ8BkUGUl1/i5mo8 U6yIN1MXpm2mytSoTd7uzXi5oJkSN7cCAY6ofhMJC4TNdsPn2gCQx9VZwVeFUukc4e6T sDEgtJfD2OWWUWYvw9HBOi7Nfl1YrGdZ9ui7x0atGgBdVmbJbxRk6Gu+fYp+IrEGb6KG Q3/Q== X-Gm-Message-State: AOJu0YyvksrLvvQ+s1Lr5ATSt5GbqKmQk7+MVOkn/r8F4ce6frBZJ/pm FDgQDs62RhpffAo6iWfnM/C5LUIz8qeYTQ9skBq41jaOMzDbasA7EErzfyH9Jf5xYXnqAQxeSzk Xifq6Q3OepvsqUWfKDHQjFoDMPkIHakG1NGk= X-Gm-Gg: ASbGnctRS5WCDaEYPiJa0E4hRsUcEUGpgzOUqCJ/dbM5k9znzgGN5Y7F+8Pm4Rb3Rjo 8Qv0WC5BIp4nNJPafgn6zzzgnoZWCVpUc0/qBv43D3PVkNsphNalT++HlXn2SMFZdfVhzogA= X-Google-Smtp-Source: AGHT+IEoDjqyDKHr21cWvv3So/gsguyGva03GBchDZp/BkdSwSu+GU0K5A0vXmSje3QebXOF5Qs9g2aSV2ftSmh1tmw= X-Received: by 2002:a05:690c:e09:b0:6ee:6e71:e6d6 with SMTP id 00721157ae682-6f5312634d0mr10761287b3.23.1736312798637; Tue, 07 Jan 2025 21:06:38 -0800 (PST) MIME-Version: 1.0 From: Igor Korot Date: Tue, 7 Jan 2025 23:06:10 -0600 X-Gm-Features: AbW1kvZjYDNvxb7BF2MiwWMKdBhQAKs7758nbQndJBlng7lZQlCP_E3twT9I0po Message-ID: Subject: Postgres do not support tinyint? To: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, ALL, According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the smallest numeric type supports numbers from -32768 to 32767/ My data will be in a range of [0..4], and so I guess my DB table will waste space, right? Thank you.