Re: Greatest of a list of columns?

čt 1. 7. 2021 v 15:26 odesílatel Ron <ronljohnsonjr(at)gmail(dot)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)

Pavel

> Thanks
>
> --
> Angular momentum makes the world go 'round.
>
>
>