Postgres Pro
Downloads
Home   >   mailing lists

Re: Subquery to select max(date) value - Mailing list pgsql-general

From Rich Shepard
Subject Re: Subquery to select max(date) value
Date
Msg-id alpine.LNX.2.20.1902121446460.15295@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Subquery to select max(date) value  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Subquery to select max(date) value  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Subquery to select max(date) value  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
Tree view 
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'.

Rich

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Subquery to select max(date) value
Next
From: Matt Zagrabelny
Date:
Subject: Re: Subquery to select max(date) value