Succinct and well presented. Thank you.

The best tutor for Postgres. I don't understand why it's not the number one video about Window Functions in Postgres.

I love how there's only one comment on this video. My search exactly for this topic and I found this video just started to watch looks good so far thanks for making this content.

That colorful `\e` 👀... ooo followed by a screen split... learning a few tricks here

Great job done for 5 min!

where have I been?

Great explanation. Thanks

hyper helpful!!

Very good and helpful explanation!

I prefer the code that is write under the a Style Guide like Joe Celko's or Simon Holywell's.

I mean. She writes ... FAAASSSSST. Crazy fast.

This video is awesome. So much knowledge in just 90 seconds. That's amazing. Thank you.

thanks for the help! 3 days trying to fix an error and you made my day :)

when i update the geolocation column with ST_MakePoint it only saves the lat long like this "POINT (-49.1162121 -26.9281947)" it doesnt save as it is shown on the video. Anyone else had this problem too?

Thanks a lot for the clarification.

Best overview of window functions I’ve seen. Keep them coming! :)

Great

Half

Thank you so much!

Can we use "having" instead of subquery?

I think the "on" condition is not necessary and can be replaced with `ON true`.

thank you!

Lateral joins are quite good , if you need data quickly , but it’s ok to stream the results over a period of time , especially loading the db data into memory cache

Thank you!

Thank you!

This was great

Simple and easy to understand, thank you

What are you typing in? I am lost before the video starts.

Can we use this to lock multiple rows for say 10 and have the same results?

Perfect explanation! Thanks a lot!

thanks

select a.name, ST_Distance(a.geolocation, b.geolocation) as distance from addresses a left join addresses b on (a.id <> b.id) where b.name = 'Hashrocket JAX' --and ST_Distance(a.geolocation, b.geolocation) < 1000 order by distance;

1:28 At this point I wasn't thinking of doing the limit -- but rather slicing the array, I believe in postgres is with [:5] notation. What would you think is better performant? Thank you for the great explanation

Simple, clear, to the point & no waste of time ⌛ Love this!! 👌🏻

Crazy I was looking for a tutorial on lateral joins and I used to run cross country with you at Eisenhower jr high

+1 for the vim!

Love your explanation, easy to follow and very nice.

hi can u help with st_within function,how can I use this ?

Wow, thanks for your time! Great tutorial

Can someone explain what is the use of SRID?

Thank you

Saved me a lot of time researching what is the benefit of LATERAL join Thanks man!

Very good job. Please add more advanced videos on Arrays, bulk collects, procedures and tuning in PostgreSQL.

Thank you !!

what if we have an even number of records?

Very fast typing

Do more videos bro. Awsome 😍

ST_DISTANCE will return distance in mts regardless of the SRID of the geometries? I think with 4326 it will return distance in degrees right?

Wow! Really great video and super easy to follow! This is great!!

Fantastic explanation, thank you