Re: AW: Cast INTEGER to BIT confusion

2023-08-15 Thread Erik Wienhold
> On 15/08/2023 14:02 CEST [Quipsy] Markus Karg wrote: > > I just tried out your proposal on PostgreSQL 15.3 and this is the result: > > ERROR: column "c" is of type bit but expression is of type integer > LINE 5: INSERT INTO t VALUES (1); > ^ > HINT: You will n

Re: AW: Cast INTEGER to BIT confusion

2023-08-15 Thread Erik Wienhold
> On 15/08/2023 13:59 CEST [Quipsy] Markus Karg wrote: > > Is setting the search path something that has to be done for each new > connection / each user, or is this something static and global for the > database? The search path is set per connection and the initial search path can be configured