Re: Fwd: compressed bits in sql table

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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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.