Divide table raw into chunks

From: Shmagi Kavtaradze <kavtaradze(dot)s(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Divide table raw into chunks
Date: 2016-02-28 11:39:08
Message-ID: CAHY6maz7csz8sjOpMypAWM6K3cZTEUBSye00UmsfGqbjt-Riqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a table with too long entries with 1s and 0s. For example I have
table :

| Sent id.| BoW. ||---------|----------|| 1 | 10100101 ||
2 | 00011110 || 3 | 10101111 |

I want to create new table which will divide column BoW. entries into some
arbitrary length and assigns chunk number.

| Sent id.| Chunk No. | BoW. ||---------|-----------|------|| 1
| 1 | 1010 || 1 | 2 | 0101 || 2 | 1
| 0001 || 2 | 2 | 1110 || 3 | 1 | 1010 ||
3 | 2 | 1111 |

I am beginner, tried to search in documentation, but without success. Maybe
something like this, but with proper function:

select b.sent_id, chunk, substring(bow from (chunk - 1) * 4 + 1 for
4)from (select b.sent_id, generate_series(1, 1 + floor(length(bow) - 1
/ 4) ) as chunk
from bow1 b
) b;

I have 4623 Sent ids (sentences) and each is 10,000 characters long. I want
to divide them into 32-40 character long chunks.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2016-02-29 18:45:38 No password supplied error when running a batch script as a programmed task
Previous Message Andreas Kretschmer 2016-02-28 08:21:32 Re: Query to return normalized floats