/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/star_expansion_failed/postgresql/pgx/query.sql
13 строк
334 B
Kyle Gray
fix(analyzer): Error on unexpanded star expression (#2882)
19 окт 2023, 18:50
Не верифицирован
19 окт 2023, 18:50
72c08a4
Код
Авторство
О чём код?
-- name: GetLatestVersionWithSubquery :one SELECT * FROM versions WHERE versions.id IN ( WITH RECURSIVE search_tree(id) AS ( SELECT id, 0 as chain_id, 0 as chain_counter FROM versions ) SELECT DISTINCT ON (search_tree.chain_id) search_tree.id FROM search_tree ORDER BY search_tree.chain_id, chain_counter DESC );