Search Postgresql Archives

Re: Subquery to select max(date) value

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Subquery to select max(date) value
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Tue, 12 Feb 2019 14:48:45 -0800 (PST)
In-reply-to: <alpine.LNX.2.20.1902121443290.15295@salmo.appl-ecosys.com>
References: <alpine.LNX.2.20.1902121414490.15295@salmo.appl-ecosys.com> <2780074d-3b87-b154-8bc6-a0f898fbdde2@openvistas.net> <alpine.LNX.2.20.1902121443290.15295@salmo.appl-ecosys.com>
Reply-to: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Subquery to select max(date) value
  - From: Ken Tanzer
- Re: Subquery to select max(date) value
  - From: Adrian Klaver

References:
- Subquery to select max(date) value
  - From: Rich Shepard
- Re: Subquery to select max(date) value
  - From: Rich Shepard

Prev by Date: Re: Subquery to select max(date) value
Next by Date: Re: Subquery to select max(date) value
Previous by thread: Re: Subquery to select max(date) value
Next by thread: Re: Subquery to select max(date) value
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux