Fun with SQL: generate_series in Postgres
Generate_series is a handy utility in Postgres that allows you to generate data starting at some point and ending at another point.
select count(*) from generate_series( '2019-03-01... - Pastebin.com
where generate_series <> date '2019-05-01'::date
sql - Using OVER function with generate_series - Stack Overflow
SELECT date::date, coalesce(positive, 0.00) as positive FROM generate_series('2018-01-10'::date, '2018-01-12', '1d') s(date) LEFT JOIN ( -- your query SELECT.
transaction_block_with_fkeys_to_ref.sql · GitHub
INSERT INTO referece_table SELECT i FROM generate_series(0, 100) i
Reduce cost of select count(*) queries with trigger-based method
SELECT count FROM table_cnt where table_oid = 'my_table'::regclass; So now let’s see what you simply get as results by comparing normal count query
Пользовательские агрегатные и оконные функции... / Хабр
Таблицу создаем на лету функцией generate_series, незаменимым помощником генерации
How to generate “0, 4, 18, 48, 100…” series in Java - Quora
import java.util.*; class series.
Generate Random Data in Postgres
You can generate random values and sequences in SQL.
COUNT Function (Aggregate) - SAP Help Portal
COUNT Function (Aggregate). Counts the number of rows returned by a query. This function can also be used as a window function.
Подстановка тела функции в SQL-запрос
В нашем случае последний оператор - SELECT, и он возвращает единственную строку. Не все команды SQL можно использовать в функции.