Search Postgresql Archives

Re: Subquery to select max(date) value [RESOLVED]

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

Subject: Re: Subquery to select max(date) value [RESOLVED]
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Tue, 12 Feb 2019 14:32:59 -0800 (PST)
In-reply-to: <CAKFQuwaW3oivY=6smmsBgF5-9qy-UC78WkOcxuyrYZd+bTgg5g@mail.gmail.com>
References: <alpine.LNX.2.20.1902121414490.15295@salmo.appl-ecosys.com> <CAKFQuwaW3oivY=6smmsBgF5-9qy-UC78WkOcxuyrYZd+bTgg5g@mail.gmail.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

On Tue, 12 Feb 2019, David G. Johnston wrote:

You put the open parenthesis after the word select instead of before.
A.next_contact = (SELECT max(A.next_contact) FROM A)


David.

Color me suitably embarrassed.

Thank you,

Rich

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

References:
- Subquery to select max(date) value
  - From: Rich Shepard
- Re: Subquery to select max(date) value
  - From: David G. Johnston

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