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: Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>
Date: Wed, 13 Feb 2019 00:44:47 +0000
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <alpine.LNX.2.20.1902121500240.15295@salmo.appl-ecosys.com> (Rich Shepard's message of "Tue, 12 Feb 2019 15:02:20 -0800 (PST)")
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> <alpine.LNX.2.20.1902121446460.15295@salmo.appl-ecosys.com> <8b99480a-7711-694e-a1c5-ae65bb0c0364@aklaver.com> <alpine.LNX.2.20.1902121500240.15295@salmo.appl-ecosys.com>
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix)

>>>>> "Rich" == Rich Shepard <rshepard@xxxxxxxxxxxxxxx> writes:

 Rich> Will probably try DISTINCT ON, too, if that makes it simpler or
 Rich> faster.

You want LATERAL.

-- 
Andrew (irc:RhodiumToad)

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

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

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

Prev by Date: Re: Subquery to select max(date) value
Next by Date: SV: SV: Implementing pgaudit extension on Microsoft Windows
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]