From: yanliang lei <msdnchina@163.com>
To: pgsql-docs@lists.postgresql.org
Subject: pg data type bool is the boolean ，but in the documents there is no description about " bool is equal to boolean”
Date: Sun, 4 Jun 2023 23:04:02 +0800 (CST)
Message-ID: <2e72e712.1b50.18886efce73.Coremail.msdnchina@163.com> (raw)
postgres=# create table test_1(c1 bool,c2 int);
CREATE TABLE
postgres=# \d+ test_1;
Table "public.test_1"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
--------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
c1 | boolean | | | | plain | | |
c2 | integer | | | | plain | | |
Access method: heap
postgres=#
in the create table statement ，there is bool data type，
in the \d+ test_1, there is boolean data type,
PostgreSQL use format_type function to convert bool to boolean.
in other words， bool datatype is equal to boolean datatype，
but the documents(https://www.postgresql.org/docs/15/datatype-boolean.html ) there is no description about " bool dataype is equal to boolean datatype ”
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: msdnchina@163.com, pgsql-docs@lists.postgresql.org
Subject: Re: =?GBK?Q?pg_data_type_bool_is_the_boolean_=A3=ACbut_in_the_documents_t?= =?GBK?Q?here_is_no_description_about_"_bool_is_equal_to_boolean=A1=B1?=
In-Reply-To: <2e72e712.1b50.18886efce73.Coremail.msdnchina@163.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox