Обсуждение: 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
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
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
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:
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:
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
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?
How were the bits encoded in the first place?
On 06/09/2018 05:43 PM, SANDEEP GOURNENI wrote:
Postgres version is 10.4field type is char(32).basically its a fee bit field.it is related to my application.thanks,SandeepOn 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.
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
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