/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/valid_group_by_reference/postgresql/query.sql
14 строк
376 B
Kyle Gray
feat(analyzer): Analyze queries using a running PostgreSQL database (#2805)
12 окт 2023, 20:32
Не верифицирован
12 окт 2023, 20:32
bb84596
Код
Авторство
О чём код?
-- name: ListAuthors :many SELECT id, name as name, bio FROM authors; -- name: ListAuthorsIdenticalAlias :many SELECT id, name as name, bio FROM authors; -- name: ListMetrics :many SELECT date_trunc('day', time) AS bucket, city_name, AVG(temp_c) FROM weather_metrics WHERE time > NOW() - (6 * INTERVAL '1 month') GROUP BY bucket, city_name ORDER BY bucket DESC;