Does anyone know how to expand a frequency table in PostgreSQL?
For example, transform table x:
data | frequency
-------+-----------
string | 4
into
data | index
-------+-------
string | 1
string | 2
string | 3
string | 4
Set up code:
CREATE TABLE x (
data TEXT,
frequency INTEGER
);
INSERT INTO x VALUES ('string',4);