Re: LET clause

2021-01-16 Thread Joel Jacobson
On Sat, Jan 16, 2021, at 17:21, Vik Fearing wrote: > I agree on the conciseness, but I'm wondering what performance problem > you think there is with the CROSS JOIN LATERAL VALUES technique. Have > you tried running an EXPLAIN (ANALYZE, VERBOSE) on that? Yes, I've tried, it results in the same pr

Re: LET clause

2021-01-16 Thread Vik Fearing
On 1/3/21 1:12 PM, Joel Jacobson wrote: > Hi hackers, > > I just learned about a feature called "LET clause". > > It's not part of the SQL standard, but it's supported by Oracle [1], > Couchbase [2] and AsterixDB [3]. > > I searched the pgsql-hackers archives and couldn't find any matches on "L

Re: LET clause

2021-01-03 Thread Pavel Stehule
Hi ne 3. 1. 2021 v 13:13 odesílatel Joel Jacobson napsal: > Hi hackers, > > I just learned about a feature called "LET clause". > > It's not part of the SQL standard, but it's supported by Oracle > [1], Couchbase [2] and AsterixDB [3]. > This is not SQL language - it uses EQL language It looks