All Questions
2 questions
4
votes
1
answer
536
views
Optimizing "random" choice in PostgreSQL
I have the following table
CREATE TABLE article (
id bigserial PRIMARY KEY,
text TEXT NOT NULL,
category_id bigint REFERENCES categories (id),
status TEXT NOT NULL,
locale TEXT ...
- 251
2
votes
1
answer
2k
views
Create a new table (multiple columns) by selecting random values from an existing table
I am stuck on the following task (PostgreSQL 9.3). Let's say we have the following table1 (which has 10k rows):
table1:
id
754
800
330
4
59
My goal is to create another table2 with two columns (...
- 21