compressed bits in sql table

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.

Thanks,
Sandeep

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?

Thanks,
Sandeep

--
Adrian Klaver
adrian.klaver@aklaver.com

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:

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
<mailto: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.

On 06/09/2018 03:43 PM, SANDEEP GOURNENI wrote:

Postgres version is 10.4
field type is char(32).basically its a fee bit field.

Can you explain what you mean by 'fee bit'?

Also not sure why you need to deal with compressed bits, cannot you not
just pull or push a string from/into the field?

it is related to my application.

thanks,
Sandeep

On Sun, Jun 10, 2018 at 4:04 AM Adrian Klaver <adrian.klaver@aklaver.com
<mailto: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?

Thanks,
Sandeep

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com