Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: Subquery to select max(date) value
Date
Msg-id alpine.LNX.2.20.1902130533500.10544@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Subquery to select max(date) value  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Vikas Sharma
Date:
Subject: Re: Out of memory: Kill process nnnn (postmaster) score nn orsacrifice child
Next
From: rob stone
Date:
Subject: Re: Server goes to Recovery Mode when run a SQL