Re: Inserting bit-type value into integer-type column - Mailing list pgsql-admin

From Tom Lane
Subject Re: Inserting bit-type value into integer-type column
Date
Msg-id 3209.1156856597@sss.pgh.pa.us
Whole thread Raw
In response to Re: Inserting bit-type value into integer-type column  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Dienstag, 29. August 2006 10:32 schrieb Riho Maisa:
>> I cannot rewrite SQL INSERT because it's in compiled application.

> Either fix your application or patch the PostgreSQL server or stick with 7.2
> (not recommended, because 7.2 is not maintained anymore).

The patch would be pretty easy though: just tweak the pg_cast entry for
bit to int casting so that it's "assignment" rather than "explicit".

            regards, tom lane

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Inserting bit-type value into integer-type column
Next
From: "Mr. Dan"
Date:
Subject: pgsql.v814 - BLCKSZ