/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/select_subquery_alias/postgresql/pgx/query.sql
10 строк
412 B
Kyle Gray
fix(compiler): Pull in array information from analyzer (#2864)
18 окт 2023, 20:29
Не верифицирован
18 окт 2023, 20:29
9ed0aca
Код
Авторство
О чём код?
-- name: FindWallets :many select id, address, balance, total_balance from ( select id, address, balance, sum(balance) over (order by balance desc rows between unbounded preceding and current row) as total_balance, sum(balance) over (order by balance desc rows between unbounded preceding and current row) - balance as last_balance from wallets where type=$1 ) amounts where amounts.last_balance < $2;