Re: Fwd: compressed bits in sql table - Mailing list pgsql-admin

From Ron
Subject Re: Fwd: compressed bits in sql table
Date
Msg-id e4c26c00-a131-d77d-1223-e1820a7162e8@gmail.com
Whole thread Raw
In response to Re: Fwd: compressed bits in sql table  (SANDEEP GOURNENI <sandeepgourneni@gmail.com>)
List pgsql-admin
Are you asking how to SELECT ... WHERE based on individual bits in this CHAR(32) field? 

How were the bits encoded in the first place?

On 06/09/2018 05:43 PM, SANDEEP GOURNENI wrote:
Postgres version is 10.4
field type is char(32).basically its a fee bit field.
it is related to my application.

thanks,
Sandeep

On Sun, Jun 10, 2018 at 4:04 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 06/09/2018 02:40 PM, SANDEEP GOURNENI wrote:
>
> Hi all,
>
> How can we read compressed bits in postgres.In one of my table field  i
> have compressed bits.how to read and write them in postgres using cobol
> program.

You are going to need to be more specific:

1) What version of Postgres?

2) What is the field type?

3) Are you referring to the TOAST table?

--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: SANDEEP GOURNENI
Date:
Subject: Re: Fwd: compressed bits in sql table
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: compressed bits in sql table