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 ”
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 |