Lines Matching refs:user_id
16 …E TABLE raw_events_first (user_id int, time timestamp, value_1 int, value_2 int, value_3 float, va… field
19 … TABLE raw_events_second (user_id int, time timestamp, value_1 int, value_2 int, value_3 float, va… field
22 …BLE agg_events (user_id int, value_1_agg int, value_2_agg int, value_3_agg float, value_4_agg bigi… field
26 CREATE TABLE reference_table (user_id int); field
36 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
38 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
40 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
42 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
44 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
46 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
57 raw_events_first.user_id
61 raw_events_first.user_id = raw_events_second.user_id
63 user_id DESC;
71 INSERT INTO raw_events_second (user_id, time)
73 user_id, now()
77 user_id < 0;
79 INSERT INTO raw_events_second (user_id)
81 user_id
100 INSERT INTO raw_events_second (user_id, value_1)
102 user_id, evaluate_on_master()
106 user_id < 0;
118 INSERT INTO raw_events_second (user_id, value_1)
120 user_id, evaluate_on_master(value_1)
124 user_id = 0;
128 INSERT INTO raw_events_first (user_id, time) VALUES
133 INSERT INTO raw_events_second (user_id, time) SELECT user_id, time FROM raw_events_first WHERE user…
139 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
145 INSERT INTO raw_events_second (value_2, value_1, value_3, value_4, user_id, time)
147 value_2, value_1, value_3, value_4, user_id, time
151 user_id = 8;
154 INSERT INTO raw_events_second (value_2, value_1, value_3, value_4, user_id, time)
156 value_2, value_1, value_3, value_4, user_id, time
164 INSERT INTO raw_events_second (value_2, value_1, value_3, value_4, user_id, time)
166 value_2, value_1, value_3, value_4, user_id, time
174 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
180 INSERT INTO raw_events_second (user_id, value_1, value_3)
182 user_id, value_1, value_3
191 INSERT INTO raw_events_second (user_id, value_1, value_3)
193 user_id, value_1, value_3
197 user_id = 9 OR user_id = 16
203 user_id, sum(value_1), avg(value_2), sum(value_3), count(value_4)
207 user_id;
210 INSERT INTO agg_events (value_3_agg, value_4_agg, value_1_agg, user_id)
212 sum(value_3), count(value_4), sum(value_1), user_id
216 value_2, user_id
223 user_id)
226 FROM (SELECT raw_events_second.user_id AS id,
230 WHERE raw_events_first.user_id = raw_events_second.user_id) AS foo
239 user_id)
245 raw_events_second.user_id AS id
248 WHERE raw_events_first.user_id = raw_events_second.user_id
249 GROUP BY raw_events_second.user_id) AS foo
256 (user_id)
261 FROM (SELECT reference_table.user_id AS id
264 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
271 raw_events_second.user_id AS id
274 WHERE raw_events_first.user_id = raw_events_second.user_id
275 GROUP BY raw_events_second.user_id
281 (user_id, value_4_agg)
289 FROM (SELECT reference_table.user_id AS id
292 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
299 raw_events_second.user_id AS id
302 WHERE raw_events_first.user_id = raw_events_second.user_id
303 GROUP BY raw_events_second.user_id
312 (user_id)
313 SELECT user_id
315 WHERE user_id IN (SELECT user_id
317 WHERE user_id = 2);
320 (user_id)
321 SELECT user_id
323 WHERE user_id IN (SELECT user_id
325 WHERE user_id != 2 AND value_1 = 2000)
326 ON conflict (user_id, value_1) DO NOTHING;
329 (user_id)
330 SELECT user_id
332 WHERE user_id IN (SELECT user_id
336 (user_id)
337 SELECT user_id
339 WHERE user_id IN (SELECT user_id
345 (user_id)
350 FROM (SELECT reference_table.user_id AS id
353 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
360 raw_events_second.user_id AS id
363 WHERE raw_events_first.user_id = raw_events_second.user_id
364 GROUP BY raw_events_second.user_id
367 WHERE f.id IN (SELECT user_id
373 user_id,
377 SELECT user_id,
381 ON conflict (user_id, value_1_agg)
389 user_id,
393 SELECT user_id,
397 ON conflict (user_id, value_1_agg)
401 RETURNING user_id, value_1_agg;
404 INSERT INTO agg_events (user_id, value_1_agg)
406 user_id, sum(value_1 + value_2)
408 raw_events_first GROUP BY user_id;
411 INSERT INTO agg_events (user_id, value_1_agg)
413 user_id, sum(value_1 + value_2) FILTER (where value_3 = 15)
415 raw_events_first GROUP BY user_id;
419 agg_events (user_id, value_1_agg)
421 raw_events_first.user_id, sum(value_1)
425 raw_events_first.user_id = reference_table.user_id
427 raw_events_first.user_id;
441 INSERT INTO raw_events_second (user_id, time, value_1, value_2, value_3, value_4) VALUES
444 DELETE FROM raw_events_second WHERE user_id = 2;
447 SELECT t1.user_id AS col1,
448 t2.user_id AS col2
451 ON t1.user_id = t2.user_id
452 ORDER BY t1.user_id,
453 t2.user_id;
458 INSERT INTO agg_events (user_id, value_1_agg)
459 SELECT t1.user_id AS col1,
460 t2.user_id AS col2
463 ON t1.user_id = t2.user_id;
468 user_id, value_1_agg
472 user_id, value_1_agg;
480 INSERT INTO agg_events (value_1_agg, user_id)
482 DISTINCT value_1, user_id
494 INSERT INTO agg_events (value_1_agg, user_id)
496 DISTINCT ON (value_1) value_1, user_id
500 SELECT user_id, value_1_agg FROM agg_events ORDER BY 1,2;
509 INSERT INTO agg_events (value_1_agg, user_id)
511 DISTINCT ON (user_id) value_1, user_id
515 SELECT user_id, value_1_agg FROM agg_events ORDER BY 1,2;
520 (SELECT max(value_1)+1 as v1_agg, user_id FROM raw_events_first GROUP BY user_id)
522 (value_1_agg, user_id)
524 v1_agg, user_id
533 raw_events_first.user_id, (SELECT * FROM sub_cte)
541 raw_events_first(user_id)
543 user_id
545 ((SELECT user_id FROM raw_events_first) UNION
546 (SELECT user_id FROM raw_events_second)) as foo;
554 raw_events_first(user_id)
555 (SELECT user_id FROM raw_events_first) INTERSECT
556 (SELECT user_id FROM raw_events_first);
561 raw_events_first(user_id)
563 user_id
565 ((SELECT user_id FROM raw_events_first WHERE user_id = 15) EXCEPT
566 (SELECT user_id FROM raw_events_second where user_id = 17)) as foo;
569 INSERT INTO agg_events (user_id)
571 raw_events_first.user_id
573 …_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id;
575 INSERT INTO agg_events (user_id)
577 raw_events_second.user_id
579 …reference_table LEFT JOIN raw_events_second ON reference_table.user_id = raw_events_second.user_id;
581 INSERT INTO agg_events (user_id)
583 raw_events_first.user_id
585 …aw_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id
586 WHERE raw_events_first.user_id = 10;
588 INSERT INTO agg_events (user_id)
590 raw_events_first.user_id
592 …aw_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id
593 WHERE raw_events_second.user_id = 10 OR raw_events_second.user_id = 11;
595 INSERT INTO agg_events (user_id)
597 raw_events_first.user_id
599 …w_events_first INNER JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id
600 WHERE raw_events_first.user_id = 10 AND raw_events_first.user_id = 20;
602 INSERT INTO agg_events (user_id)
604 raw_events_first.user_id
606 …aw_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id
607 WHERE raw_events_first.user_id = 10 AND raw_events_second.user_id = 20;
609 INSERT INTO agg_events (user_id)
611 raw_events_first.user_id
613 …aw_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id
614 WHERE raw_events_first.user_id IN (19, 20, 21);
616 INSERT INTO agg_events (user_id)
618 raw_events_first.user_id
620 …w_events_first INNER JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.user_id
621 WHERE raw_events_second.user_id IN (19, 20, 21);
629 (user_id)
630 SELECT raw_events_first.user_id
633 WHERE raw_events_second.user_id = raw_events_first.value_1
638 INSERT INTO agg_events (user_id)
640 raw_events_first.user_id
642 …raw_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.value…
645 INSERT INTO agg_events (user_id)
647 raw_events_first.user_id
649 …raw_events_first INNER JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.valu…
653 (user_id)
654 SELECT raw_events_second.user_id
657 WHERE raw_events_first.user_id = raw_events_first.value_1;
660 INSERT INTO agg_events (user_id)
662 raw_events_first.user_id
670 INSERT INTO agg_events (user_id)
672 raw_events_first.user_id
679 INSERT INTO agg_events (user_id)
681 raw_events_first.user_id
687 INSERT INTO agg_events (user_id)
689 raw_events_first.user_id
691 …raw_events_first LEFT JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.value…
693 raw_events_first.user_id = 10;
699 INSERT INTO agg_events (user_id)
701 raw_events_first.user_id
703 …raw_events_first INNER JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.valu…
704 WHERE raw_events_first.user_id = 10;
711 INSERT INTO agg_events (user_id)
713 raw_events_first.user_id
715 …raw_events_first INNER JOIN raw_events_second ON raw_events_first.user_id = raw_events_second.valu…
716 WHERE raw_events_first.value_1 IN (10, 11,12) OR raw_events_second.user_id IN (1,2,3,4);
724 (user_id)
725 SELECT raw_events_first.user_id
728 WHERE raw_events_second.user_id = raw_events_first.value_1;
739 (user_id)
740 SELECT raw_events_first.user_id
743 WHERE raw_events_second.user_id = raw_events_first.value_1
752 (user_id, value_4_agg)
760 FROM (SELECT reference_table.user_id AS id
763 ON (raw_events_first.value_1 = reference_table.user_id)) AS foo) as f
770 raw_events_second.user_id AS id
773 WHERE raw_events_first.user_id = raw_events_second.user_id
774 GROUP BY raw_events_second.user_id
786 (user_id)
787 SELECT raw_events_first.user_id
790 WHERE raw_events_second.user_id = raw_events_first.value_1
799 (user_id, value_4_agg)
807 FROM (SELECT reference_table.user_id AS id
810 ON (raw_events_first.value_1 = reference_table.user_id)) AS foo) as f
817 raw_events_second.user_id AS id
820 WHERE raw_events_first.user_id = raw_events_second.user_id
821 GROUP BY raw_events_second.user_id
831 user_id)
837 raw_events_second.user_id AS id
840 WHERE raw_events_first.user_id != raw_events_second.user_id
841 GROUP BY raw_events_second.user_id) AS foo;
850 user_id)
859 WHERE raw_events_first.user_id = raw_events_second.user_id
871 SELECT user_id
875 (user_id)
880 (user_id)
881 SELECT user_id * 2
885 (user_id)
886 SELECT user_id :: bigint
894 user_id)
897 user_id,
901 GROUP BY user_id;
908 user_id)
911 user_id,
915 GROUP BY user_id,
919 INSERT INTO agg_events (user_id)
921 user_id
927 (user_id)
931 FROM (SELECT reference_table.user_id AS id
934 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
941 SUM(raw_events_second.user_id) AS id
944 WHERE raw_events_first.user_id = raw_events_second.user_id
955 (user_id)
959 FROM (SELECT raw_events_first.user_id AS id
962 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
969 SUM(raw_events_second.user_id) AS id
972 WHERE raw_events_first.user_id = raw_events_second.user_id
984 (user_id, value_4_agg)
992 FROM (SELECT reference_table.user_id AS id
995 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1002 raw_events_second.user_id AS id
1005 WHERE raw_events_first.user_id = raw_events_second.user_id
1006 GROUP BY raw_events_second.user_id
1017 (user_id, value_4_agg)
1025 FROM (SELECT reference_table.user_id AS id
1028 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1035 raw_events_second.user_id AS id
1038 WHERE raw_events_first.user_id = raw_events_second.value_1
1039 GROUP BY raw_events_second.user_id
1051 (user_id, value_4_agg)
1059 FROM (SELECT reference_table.user_id AS id
1062 WHERE raw_events_first.user_id != reference_table.user_id ) AS foo) as f
1069 raw_events_second.user_id AS id
1072 WHERE raw_events_first.user_id = raw_events_second.user_id
1073 GROUP BY raw_events_second.user_id
1085 INSERT INTO agg_events (user_id, value_4_agg)
1087 averages.user_id, avg(averages.value_4)
1090 raw_events_second.user_id
1092 … reference_table JOIN raw_events_second on (reference_table.user_id = raw_events_second.user_id)
1096 user_id, value_4
1099 value_4 = reference_ids.user_id) as averages ON true
1100 GROUP BY averages.user_id;
1107 INSERT INTO agg_events (user_id, value_4_agg)
1109 averages.user_id, avg(averages.value_4)
1112 raw_events_second.user_id
1114 … reference_table JOIN raw_events_second on (reference_table.user_id = raw_events_second.user_id)
1118 user_id, value_4
1120 raw_events_first) as averages ON averages.value_4 = reference_ids.user_id
1121 GROUP BY averages.user_id;
1128 INSERT INTO agg_events (user_id, value_4_agg)
1130 averages.user_id, avg(averages.value_4)
1133 raw_events_second.user_id
1135 … reference_table JOIN raw_events_second on (reference_table.user_id = raw_events_second.user_id)
1139 user_id, value_4
1141 raw_events_first) as averages ON averages.user_id = reference_ids.user_id
1143 (SELECT user_id, value_4 FROM agg_events) as agg_ids ON (agg_ids.value_4 = averages.user_id)
1144 GROUP BY averages.user_id;
1152 (user_id)
1153 SELECT user_id
1155 WHERE user_id IN (SELECT value_1
1164 (user_id)
1169 FROM (SELECT reference_table.user_id AS id
1172 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1179 raw_events_second.user_id AS id
1182 WHERE raw_events_first.user_id = raw_events_second.user_id
1183 GROUP BY raw_events_second.user_id
1196 (user_id)
1197 SELECT user_id
1199 WHERE user_id IN (SELECT raw_events_second.user_id
1201 … WHERE raw_events_second.user_id = raw_events_first.user_id AND raw_events_first.user_id = 200);
1210 (user_id)
1211 SELECT user_id
1213 WHERE user_id NOT IN (SELECT raw_events_second.user_id
1215 … WHERE raw_events_second.user_id = raw_events_first.user_id AND raw_events_first.user_id = 200);
1222 (user_id)
1223 SELECT user_id
1227 WHERE raw_events_second.user_id =raw_events_first.user_id);
1231 (user_id)
1232 SELECT user_id
1236 WHERE raw_events_second.user_id =raw_events_first.user_id);
1241 (user_id, value_4_agg)
1249 FROM (SELECT raw_events_first.user_id AS id
1252 ON (raw_events_first.user_id = reference_table.user_id)) AS foo) as f
1259 raw_events_second.user_id AS id
1262 WHERE raw_events_first.user_id = raw_events_second.user_id
1263 GROUP BY raw_events_second.user_id
1276 (user_id)
1277 SELECT user_id
1279 WHERE user_id IN (
1283 FROM (SELECT reference_table.user_id AS id
1286 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1293 raw_events_second.user_id AS id
1296 WHERE raw_events_first.user_id = raw_events_second.user_id
1297 GROUP BY raw_events_second.user_id
1309 (user_id)
1310 SELECT user_id
1312 WHERE user_id IN (
1316 FROM (SELECT reference_table.user_id AS id
1319 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1326 raw_events_second.user_id AS id
1329 WHERE raw_events_first.user_id = raw_events_second.user_id
1330 GROUP BY raw_events_second.user_id
1333 WHERE f.id IN (SELECT user_id
1340 (user_id)
1341 SELECT user_id
1343 WHERE user_id NOT IN (
1347 FROM (SELECT reference_table.user_id AS id
1350 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1357 raw_events_second.user_id AS id
1360 WHERE raw_events_first.user_id = raw_events_second.user_id
1361 GROUP BY raw_events_second.user_id
1364 WHERE f.id IN (SELECT user_id
1369 (user_id)
1370 SELECT user_id
1372 WHERE user_id IN (
1376 FROM (SELECT reference_table.user_id AS id
1379 WHERE raw_events_first.user_id = reference_table.user_id ) AS foo) as f
1386 raw_events_second.user_id AS id
1389 WHERE raw_events_first.user_id = raw_events_second.user_id
1390 GROUP BY raw_events_second.user_id
1393 WHERE f.id IN (SELECT user_id
1398 (user_id,
1401 SELECT user_id,
1405 GROUP BY grouping sets ( ( user_id ), ( value_1 ), ( user_id, value_1 ), ( ) );
1415 INSERT INTO agg_events(user_id)
1416 SELECT user_id
1418 WHERE user_id
1420 user_id
1424 user_id
1428 e1.user_id
1432 e1.user_id = u1.user_id LIMIT 3
1450 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 100;
1459 INSERT INTO raw_events_first (user_id)
1460 SELECT user_id FROM raw_events_second JOIN reference_table USING (user_id);
1467 INSERT INTO raw_events_first (user_id)
1468 SELECT user_id FROM raw_events_second JOIN reference_table USING (user_id);
1473 COPY raw_events_second (user_id, value_1) FROM STDIN DELIMITER ',';
1482 COPY raw_events_second (user_id, value_1) FROM STDIN DELIMITER ',';
1485 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 101;
1486 SELECT user_id FROM raw_events_first WHERE user_id = 101;
1491 COPY raw_events_first (user_id, value_1) FROM STDIN DELIMITER ',';
1497 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 100;
1498 COPY raw_events_first (user_id, value_1) FROM STDIN DELIMITER ',';
1505 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 100;
1506 COPY raw_events_first (user_id, value_1) FROM STDIN DELIMITER ',';
1509 INSERT INTO raw_events_first (user_id, value_1) VALUES (105, 105), (106, 106);
1514 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
1518 INSERT INTO raw_events_first (user_id, time, value_1, value_2, value_3, value_4) VALUES
1520 INSERT INTO raw_events_second SELECT * FROM test_view WHERE user_id = 17 GROUP BY 1,2,3,4,5,6;
1528 INSERT INTO raw_events_second (user_id)
1530 user_id
1551 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 5;
1564 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 5;
1567 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 6;
1587 INSERT INTO raw_events_first SELECT * FROM raw_events_second WHERE user_id = 5;
1823 INSERT INTO raw_events_first (user_id, value_1)
1826 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id;
1835 INSERT INTO raw_events_first (user_id, value_1, value_2)
1841 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1844 INSERT INTO raw_events_first (user_id, value_1)
1849 INSERT INTO raw_events_first (user_id, value_1)
1859 INSERT INTO raw_events_first (user_id, value_1)
1861 SELECT user_id, value_1 FROM raw_events_first ORDER BY 1;
1868 INSERT INTO raw_events_first (user_id, value_1)
1870 SELECT user_id, value_1 FROM raw_events_first WHERE user_id = 1;
1879 INSERT INTO raw_events_first (user_id, value_1)
1882 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1887 INSERT INTO raw_events_first (value_1, user_id)
1890 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1895 INSERT INTO raw_events_first (value_3, user_id)
1900 SELECT user_id, value_3 FROM raw_events_first ORDER BY user_id, value_3;
1906 INSERT INTO raw_events_second (user_id, value_4)
1909 INSERT INTO raw_events_first (user_id, value_1)
1910 SELECT user_id, value_4 FROM raw_events_second LIMIT 5;
1912 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1920 INSERT INTO raw_events_first (user_id, value_1)
1924 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1938 INSERT INTO raw_events_first (user_id, value_1)
1950 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1958 INSERT INTO raw_events_first (user_id, value_1)
1964 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1970 SELECT user_id, value_4 FROM raw_events_second WHERE user_id = 2
1972 INSERT INTO raw_events_first (user_id, value_1)
1975 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
1981 INSERT INTO raw_events_first(user_id, value_1)
1999 CREATE TABLE dist_table_with_sequence (user_id serial, value_1 serial); field
2006 SELECT * FROM dist_table_with_sequence ORDER BY user_id, value_1;
2012 SELECT * FROM dist_table_with_sequence ORDER BY user_id, value_1;
2016 INSERT INTO dist_table_with_sequence (user_id)
2017 SELECT user_id FROM raw_events_second ORDER BY user_id;
2019 SELECT * FROM dist_table_with_sequence ORDER BY user_id, value_1;
2022 SELECT user_id FROM raw_events_second WHERE value_1 IS NOT NULL ORDER BY value_1 LIMIT 10
2027 SELECT * FROM dist_table_with_sequence ORDER BY user_id, value_1;
2030 INSERT INTO dist_table_with_sequence (user_id)
2031 SELECT user_id FROM dist_table_with_sequence WHERE user_id = 1;
2033 SELECT * FROM dist_table_with_sequence ORDER BY user_id, value_1;
2040 CREATE TABLE dist_table_with_user_sequence (user_id int default nextval('seq1'), value_1 bigint def… field
2047 SELECT * FROM dist_table_with_user_sequence ORDER BY user_id, value_1;
2053 SELECT * FROM dist_table_with_user_sequence ORDER BY user_id, value_1;
2057 INSERT INTO dist_table_with_user_sequence (user_id)
2058 SELECT user_id FROM raw_events_second ORDER BY user_id;
2060 SELECT * FROM dist_table_with_user_sequence ORDER BY user_id, value_1;
2063 SELECT user_id FROM raw_events_second WHERE value_1 IS NOT NULL ORDER BY value_1 LIMIT 10
2068 SELECT * FROM dist_table_with_user_sequence ORDER BY user_id, value_1;
2071 INSERT INTO dist_table_with_user_sequence (user_id)
2072 SELECT user_id FROM dist_table_with_user_sequence WHERE user_id = 1;
2074 SELECT * FROM dist_table_with_user_sequence ORDER BY user_id, value_1;
2080 CREATE TABLE ref_table (user_id serial, value_1 int); field
2084 SELECT user_id, value_1 FROM raw_events_second;
2086 SELECT * FROM ref_table ORDER BY user_id, value_1;
2091 SELECT * FROM ref_table ORDER BY user_id, value_1;
2094 SELECT * FROM ref_table ORDER BY user_id, value_1;
2100 CREATE TABLE ref_table_with_user_sequence (user_id int default nextval('seq1'), value_1 int); field
2104 SELECT user_id, value_1 FROM raw_events_second;
2106 SELECT * FROM ref_table_with_user_sequence ORDER BY user_id, value_1;
2111 SELECT * FROM ref_table_with_user_sequence ORDER BY user_id, value_1;
2114 SELECT * FROM ref_table_with_user_sequence ORDER BY user_id, value_1;
2139 CREATE TABLE insert_append_table (user_id int, value_4 bigint); field
2142 INSERT INTO insert_append_table (user_id, value_4)
2143 SELECT user_id, 1 FROM raw_events_second LIMIT 5;
2151 INSERT INTO raw_events_first (user_id, value_1)
2161 SELECT user_id, value_1 FROM raw_events_first ORDER BY user_id, value_1;
2169 SELECT user_id, value_4 FROM test_view ORDER BY user_id, value_4;
2181 SELECT value_4, user_id FROM raw_events_second LIMIT 5;
2191 CREATE TABLE coerce_events(user_id int, time timestamp, value_1 numeric); field
2194 CREATE TABLE coerce_agg (user_id int, value_1_agg int); field
2197 INSERT INTO coerce_events(user_id, value_1) VALUES (1, 1), (2, 2), (10, 10);
2200 INSERT INTO coerce_agg(user_id, value_1_agg)
2203 SELECT user_id, value_1
2211 INSERT INTO coerce_agg(user_id, value_1_agg)
2214 SELECT user_id, value_1
2225 INSERT INTO coerce_agg(user_id, value_1_agg)
2228 SELECT user_id, value_1
2240 INSERT INTO coerce_events(user_id, value_1) VALUES (1, 'aaaaa'), (2, 'bbbbb');
2241 INSERT INTO coerce_agg(user_id, value_1_agg)
2244 SELECT user_id, value_1
2252 INSERT INTO coerce_agg(user_id, value_1_agg)
2255 SELECT user_id, value_1
2269 INSERT INTO coerce_events (user_id, value_1) VALUES (1, 1), (10, 10);
2273 INSERT INTO coerce_agg(user_id, value_1_agg)
2276 SELECT user_id, value_1
2287 INSERT INTO coerce_events(user_id, value_1) VALUES (1, '{1,1,1}'), (2, '{2,2,2}');
2290 INSERT INTO coerce_agg(user_id, value_1_agg)
2293 SELECT user_id, value_1
2317 user_id,
2321 SELECT user_id,
2325 ON conflict (user_id, value_1_agg)
2327 SET user_id = 42
2328 RETURNING user_id, value_1_agg;