Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
čt 1. 7. 2021 v 15:26 odesílatel Ron <ronljohnsonjr@gmail.com> napsal:Postgresql 12.5 What's the canonical Postgresql method for doing, for example, this? SELECT relname, MAXOF(last_vacuum, last_autovacuum) FROM pg_stat_user_tables; Seeing both last_vacuum and last_autovacuum is useful, of course, but sometimes I only want to see the "really" last time it was vacuumed. I can hard code a case statement, but a generic multi-column solution is preferred. postgres=# select greatest(current_date, current_date + 1);┌────────────┐│ greatest │╞════════════╡│ 2021-07-02 │└────────────┘(1 row)
Postgresql 12.5 What's the canonical Postgresql method for doing, for example, this? SELECT relname, MAXOF(last_vacuum, last_autovacuum) FROM pg_stat_user_tables; Seeing both last_vacuum and last_autovacuum is useful, of course, but sometimes I only want to see the "really" last time it was vacuumed. I can hard code a case statement, but a generic multi-column solution is preferred.
Pavel Thanks -- Angular momentum makes the world go 'round.
Thanks -- Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: