Re: AW: AW: Cast INTEGER to BIT confusion - Mailing list pgsql-general

From Erik Wienhold
Subject Re: AW: AW: Cast INTEGER to BIT confusion
Date
Msg-id 2102137877.358573.1692279441321@office.mailbox.org
Whole thread Raw
In response to Re: AW: AW: Cast INTEGER to BIT confusion  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: AW: AW: Cast INTEGER to BIT confusion
List pgsql-general
> On 17/08/2023 15:18 CEST Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> That's probably because the grammar uses SystemTypeName (effectively
> prepending "pg_catalog.") for any type that has special syntax called
> out in the SQL standard.  You could get around that in various ways,
> but they all involve changing the way the CREATE TABLE command is
> written, because just plain "BIT" is a SQL-mandated special case.

The answer I was looking for.  Thanks Tom.

--
Erik



pgsql-general by date:

Previous
From: Sai Teja
Date:
Subject: Re: Fatal Error : Invalid Memory alloc request size 1236252631
Next
From: Karsten Hilbert
Date:
Subject: Aw: Re: Fatal Error : Invalid Memory alloc request size 1236252631