|
1 | | -CREATE EXTENSION |
2 | | -CREATE TABLE |
3 | | -CREATE TABLE |
4 | | -INSERT 0 6 |
| 1 | +create extension vops; |
| 2 | +create table s(x real); |
| 3 | +create table v(x vops_float4); |
| 4 | +insert into s values(1.0),(2.0),(null),(3.0),(null),(4.0); |
| 5 | +select populate(destination:='v'::regclass, source:='s'::regclass); |
5 | 6 | populate |
6 | 7 | ---------- |
7 | 8 |
|
8 | 9 | (1 row) |
9 | 10 |
|
| 11 | +select unnest(v.*) from v where x > 1; |
10 | 12 | unnest |
11 | 13 | -------- |
12 | 14 | (2) |
13 | 15 | (3) |
14 | 16 | (4) |
15 | 17 | (3 rows) |
16 | 18 |
|
| 19 | +select countall(*) from v where x is not null; |
17 | 20 | countall |
18 | 21 | ---------- |
19 | 22 | 4 |
20 | 23 | (1 row) |
21 | 24 |
|
| 25 | +select count(*) from v where x is null; |
22 | 26 | count |
23 | 27 | ------- |
24 | 28 | 60 |
25 | 29 | (1 row) |
26 | 30 |
|
| 31 | +select count(*) from v where x is not null; |
27 | 32 | count |
28 | 33 | ------- |
29 | 34 | 4 |
30 | 35 | (1 row) |
31 | 36 |
|
| 37 | +select count(*),count(x),sum(x),avg(x),min(x),max(x),variance(x),var_pop(x),var_samp(x),stddev(x),stddev_pop(x),stddev_samp(x) from v where x >= 0.0; |
32 | 38 | count | count | sum | avg | min | max | variance | var_pop | var_samp | stddev | stddev_pop | stddev_samp |
33 | 39 | -------+-------+-----+-----+-----+-----+------------------+---------+------------------+------------------+------------------+------------------ |
34 | 40 | 4 | 4 | 10 | 2.5 | 1 | 4 | 1.66666666666667 | 1.25 | 1.66666666666667 | 1.29099444873581 | 1.11803398874989 | 1.29099444873581 |
35 | 41 | (1 row) |
36 | 42 |
|
| 43 | +select count(*),count(x),sum(x),avg(x),min(x),max(x),variance(x),var_pop(x),var_samp(x),stddev(x),stddev_pop(x),stddev_samp(x) from s where x >= 0.0; |
37 | 44 | count | count | sum | avg | min | max | variance | var_pop | var_samp | stddev | stddev_pop | stddev_samp |
38 | 45 | -------+-------+-----+-----+-----+-----+------------------+---------+------------------+------------------+------------------+------------------ |
39 | 46 | 4 | 4 | 10 | 2.5 | 1 | 4 | 1.66666666666667 | 1.25 | 1.66666666666667 | 1.29099444873581 | 1.11803398874989 | 1.29099444873581 |
40 | 47 | (1 row) |
41 | 48 |
|
| 49 | +select count(*),count(x),sum(x),avg(x),min(x),max(x),variance(x),var_pop(x),var_samp(x),stddev(x),stddev_pop(x),stddev_samp(x) from v where x > 1.0; |
42 | 50 | count | count | sum | avg | min | max | variance | var_pop | var_samp | stddev | stddev_pop | stddev_samp |
43 | 51 | -------+-------+-----+-----+-----+-----+----------+-------------------+----------+--------+-------------------+------------- |
44 | 52 | 3 | 3 | 9 | 3 | 2 | 4 | 1 | 0.666666666666667 | 1 | 1 | 0.816496580927726 | 1 |
45 | 53 | (1 row) |
46 | 54 |
|
| 55 | +select count(*),count(x),sum(x),avg(x),min(x),max(x),variance(x),var_pop(x),var_samp(x),stddev(x),stddev_pop(x),stddev_samp(x) from s where x > 1.0; |
47 | 56 | count | count | sum | avg | min | max | variance | var_pop | var_samp | stddev | stddev_pop | stddev_samp |
48 | 57 | -------+-------+-----+-----+-----+-----+----------+-------------------+----------+--------+-------------------+------------- |
49 | 58 | 3 | 3 | 9 | 3 | 2 | 4 | 1 | 0.666666666666667 | 1 | 1 | 0.816496580927726 | 1 |
|