Re: Subquery to select max(date) value

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Subquery to select max(date) value
Date: 2019-02-13 13:34:20
Message-ID: alpine.LNX.2.20.1902130533500.10544@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 13 Feb 2019, Andrew Gierth wrote:

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

Andrew,

That's new to me so I'll read about it.

Thanks,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2019-02-13 13:41:51 Re: Server goes to Recovery Mode when run a SQL
Previous Message Vikas Sharma 2019-02-13 12:40:39 Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child