Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Gierth
Subject Re: Subquery to select max(date) value
Date
Msg-id 87va1oplgl.fsf@news-spur.riddles.org.uk
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  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: Subquery to select max(date) value  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view 
>>>>> "Rich" == Rich Shepard <rshepard@appl-ecosys.com> writes:

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

You want LATERAL.

-- 
Andrew (irc:RhodiumToad)

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Subquery to select max(date) value
Next
From: Niels Jespersen
Date:
Subject: SV: SV: Implementing pgaudit extension on Microsoft Windows