On Tuesday, August 15, 2023, Erik Wienhold <e...@ewie.name> wrote: > > On 15/08/2023 10:49 CEST [Quipsy] Markus Karg <k...@quipsy.de> wrote: > > > > Hello PostgreSQL Community, > > > > I like to store just a single bit but that can be either 1 or 0, so I > tried > > You could create a custom domain if you're only interested in values 0 and > 1 > and don't use bit string functions. The search path must be changed so > that > domain bit overrides pg_catalog.bit:
The table using the system bit type already exists and thus the oid for the data type of the stored catalog column is that of the system bit type. Creating a user bit domaim is going to have absolutely zero impact on this situation. If you really want to make this work and are willing to risk and deal with side-effects of manual catalog updates you could maybe make the existing cast implicit. David J.
