Re: Add Boolean node - Mailing list pgsql-hackers

From Sascha Kuhl
Subject Re: Add Boolean node
Date
Msg-id CAPvVvKCbBGm480mVsWn06EbNG1Mc7onLvp1+YALcwaRzFptoaQ@mail.gmail.com
Whole thread Raw
In response to Re: Add Boolean node  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Add Boolean node  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Can that boolean node be cultural dependent validation for the value? By the developer? By all?

Pavel Stehule <pavel.stehule@gmail.com> schrieb am Mo., 27. Dez. 2021, 10:09:


po 27. 12. 2021 v 10:02 odesílatel Peter Eisentraut <peter.eisentraut@enterprisedb.com> napsal:

This patch adds a new node type Boolean, to go alongside the "value"
nodes Integer, Float, String, etc.  This seems appropriate given that
Boolean values are a fundamental part of the system and are used a lot.

Before, SQL-level Boolean constants were represented by a string with
a cast, and internal Boolean values in DDL commands were usually
represented by Integer nodes.  This takes the place of both of these
uses, making the intent clearer and having some amount of type safety.

+1

Regards

Pavel

pgsql-hackers by date:

Previous
From: wenjing zeng
Date:
Subject: why does reindex invalidate relcache without modifying system tables
Next
From: Pavel Stehule
Date:
Subject: Re: Add Boolean node