pg data type bool is the boolean ,but in the documents there is no description about " bool is equal to boolean”

From: "yanliang lei" <msdnchina(at)163(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: pg data type bool is the boolean ,but in the documents there is no description about " bool is equal to boolean”
Date: 2023-06-04 15:04:02
Message-ID: 2e72e712.1b50.18886efce73.Coremail.msdnchina@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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 ”

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Erik Wienhold 2023-06-04 15:38:18 Re: pg data type bool is the boolean ,but in the documents there is no description about " bool is equal to boolean”
Previous Message Lorusso Domenico 2023-06-01 16:41:56 Re: pass open cursor via USING in execute staement