Re: Subquery to select max(date) value
От
Adrian Klaver
Тема
Re: Subquery to select max(date) value
Дата
Msg-id
8b99480a-7711-694e-a1c5-ae65bb0c0364@aklaver.com
Ответ на
Re: Subquery to select max(date) value (Rich Shepard)
Список
Дерево обсуждения
Subquery to select max(date) value Rich Shepard <rshepard@appl-ecosys.com>
Re: Subquery to select max(date) value Jan Kohnert <nospam001-lists@jan-kohnert.de>
Re: Subquery to select max(date) value "David G. Johnston" <david.g.johnston@gmail.com>
Re: Subquery to select max(date) value [RESOLVED] Rich Shepard <rshepard@appl-ecosys.com>
Re: Subquery to select max(date) value Matt Zagrabelny <mzagrabe@d.umn.edu>
On 2/12/19 2:48 PM, Rich Shepard wrote: > On Tue, 12 Feb 2019, Rich Shepard wrote: > >> A.next_contact = (select (max(A.next_contact)) from Activities as A) > > Errata: > > The parentheses around the max aggregate are not necessary. > > A.next_contact now displays at the end of each returned row as 'infinity'. 'infinity' is the max date, so this is what you want? > > Rich > > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления
