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 1tVPnm-008ADB-RA for pgsql-general@arkaria.postgresql.org; Wed, 08 Jan 2025 06:44:27 +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 1tVPnl-00DleE-Pp for pgsql-general@arkaria.postgresql.org; Wed, 08 Jan 2025 06:44:25 +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 1tVPnl-00Dlb7-EQ for pgsql-general@lists.postgresql.org; Wed, 08 Jan 2025 06:44:25 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tVPni-000T2s-37 for pgsql-general@lists.postgresql.org; Wed, 08 Jan 2025 06:44:24 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-29fc424237bso7797300fac.0 for ; Tue, 07 Jan 2025 22:44:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736318662; x=1736923462; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ggodlKO9rhBI44Jkhu9jCa6oPwBbt8mz7ptv/qmWqiE=; b=EKiannP8/GflWW249d7DCXUv5zwH41WDKd5TClsOhk/43li5umrVrgetU46e9wC5KH 1FHrsd7RXo8apf3Ta55LNsX0pD6zlMJLykfTQXbPc+JQtdm8/6Rg5DF96/Fc7FPx02vP mEEjF1Tki1k0hf7bzZt5clpxNmwn37LGsqlbqClQ1IXeMvyd23kZqgJPjeSykiCXAcMh W73SCgiVzNLpx4dZzeNK/d3PylSf6GAZmrWAjvPNVHEYgWbgM2/fPNi1MN4yIoG8vMLz EhCD11L0FtVf3accDC99W47qCnTkWwV4HX08dXVdLM9ebU0XEzVasJ65B59ZKItgHgNE Jtmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736318662; x=1736923462; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ggodlKO9rhBI44Jkhu9jCa6oPwBbt8mz7ptv/qmWqiE=; b=ouGctv/HRhv6Nfo22Xr8ZwnfwqDIMGJJ/kM42kYACnjLzvxsXNIfEHOS5SkXI6+cbV fPXe1bjz6pQkGiDgSGPBUyl11vudDBMvROqrgUSUsgXRS+xfAnqi/tOxNQaPqW6jR+N/ Q09Gq9fk12Ncqm6o4cf1x1mXwxLMIE8Mlt1evWWNaCiWcaIQ0lsV/PWy5Iuenw7W0iBu vT8ol0YjAV5+nacrcm9piMNSyB9DNQrNxnzmfSNPrn5dlAtyeu7WuP2AQ/PDqGVx5GyA km/TYE/oK/o6fPFyAiB+hi+NispzfK3zhuyOs5yYbp0pn+9nKryLZXMxVKP6lvhrxJZe cDuA== X-Gm-Message-State: AOJu0Yys33KmOAxg9+vCmlLU83KUpNaKpddMoGwwCxQmdjRbeQQzJH3Y 7SQj2M7O6vWg+A0MS6U3aJb4Vk4uJWNspG0T+5qflMWEgeizxaINAQyr5OYRGuSrdZ7pddIwelt Rj8N5QHiNZVrpTRJtE9OfbkF6vW0= X-Gm-Gg: ASbGncuPYVtHcs0WbYj+SL7KFHD5kDE5X0oChmIJXikfMU5cpEH44fhrzjh03fchU9c geJkh7U9SywR0VSXZvs3aRe/jjT7BqKmToMKCjg== X-Google-Smtp-Source: AGHT+IHjxoifYUzVmbIJajzdJ9yHQIp7IUHzuUQl0tzX9/HkjffvlaUvm//niBmonej8HBCTxr71EcaZkYGxUOV++lY= X-Received: by 2002:a05:6871:2283:b0:2a7:d345:c0bb with SMTP id 586e51a60fabf-2aa069763f5mr944043fac.27.1736318661927; Tue, 07 Jan 2025 22:44:21 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:1a87:b0:577:9519:f64a with HTTP; Tue, 7 Jan 2025 22:44:21 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 7 Jan 2025 23:44:21 -0700 X-Gm-Features: AbW1kvZOVLs5Iy53w8xXPDyV_RlEbWJyHYGeaK54X0FlxIDpP_leU81CciEa1g4 Message-ID: Subject: Re: Postgres do not support tinyint? To: Ron Johnson Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000fa8a7062b2c311a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000fa8a7062b2c311a Content-Type: text/plain; charset="UTF-8" On Tuesday, January 7, 2025, Ron Johnson wrote: > > 3. The "bit" type might serve your needs. > > You suggest a type with a minimum size of 6 bytes when the complaint is that the otherwise acceptable 2 byte data type is too large? David J. --0000000000000fa8a7062b2c311a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, January 7, 2025, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

3. The "bi= t" type might serve your needs.


You suggest a type with a minimum size of 6 bytes when= the complaint is that the otherwise acceptable 2 byte data type is too lar= ge?

David J.

--0000000000000fa8a7062b2c311a--