From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Fwd: compressed bits in sql table
Date: Sat, 9 Jun 2018 18:29:54 -0500
Message-ID: <e4c26c00-a131-d77d-1223-e1820a7162e8@gmail.com> (raw)
In-Reply-To: <CAB7YabOp+Z9DMuVLuQ7zPJgR3HMmt30y3deRu+fcUML1jsCECg@mail.gmail.com>
References: <CAB7YabOTcSKt3c7g3r2VZxB0TZawT7qykBxC2dSh4v28VLFuxg@mail.gmail.com>
<CAB7YabPX_+NzFaz2Yeqx1Q+speavwZoD-8NG9EhXojYEk=Sw-A@mail.gmail.com>
<52af8d9e-e6bf-9db7-ee4c-29beaaab28ec@aklaver.com>
<CAB7YabOp+Z9DMuVLuQ7zPJgR3HMmt30y3deRu+fcUML1jsCECg@mail.gmail.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?
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Fwd: compressed bits in sql table
In-Reply-To: <e4c26c00-a131-d77d-1223-e1820a7162e8@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox