Re: Greatest of a list of columns?

2021-07-01 Thread Pavel Stehule
čt 1. 7. 2021 v 15:27 odesílatel Pavel Stehule napsal: > > > čt 1. 7. 2021 v 15:26 odesílatel Ron 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; >> >> S

Re: Greatest of a list of columns?

2021-07-01 Thread Pavel Stehule
čt 1. 7. 2021 v 15:26 odesílatel Ron 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 > s

Greatest of a list of columns?

2021-07-01 Thread Ron
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 va