Database Programming

LEAD() Window Function – with examples in PostgreSQL

Having been forewarned in several of my previous blog posts that I am on a SQL Window Function kick, it should be no surprise that here I am again; sharing what I am studying and learning. I continue to find these powerful constructs highly interesting, to say the least. In this post, I visit the LEAD() Window Function with examples in PostgreSQL. Read on and let’s learn something together…

[Head this way for great PostgresSQL blogging >>>]
Advertisements

Window Function windowing options – with examples in PostgreSQL

More window functions here on the blog? What can I say? The deeper I get into them, the more I realize their power. Yet, I have not covered any of the Windowing options available in the OVER() clause so far and that ends with this post. I will share what I have learned, and what I am still learning. Join me and we can learn together…

[Head this way for great PostgresSQL blogging >>>]

Date and Time calculations using INTERVAL – with examples in PostgreSQL.

Saying time is important is to state the obvious. Our lives are built on time. We only have so much of it and once it is gone, there is no getting it back. While not as important as that time, date and time data values are integral pieces in most –if not all– database infrastructure and design. At some point or another, date and time values must be considered. PostgreSQL has many functions and options for date and time value manipulation. In this post, I look at the INTERVAL type for date and time calculations….

[Head this way for great PostgresSQL blogging >>>]

The EXTRACT() function with examples in PostgreSQL

At times, you may only need a certain portion of a date interval or TIMESTAMP. Luckily in PostgreSQL, we have the EXTRACT() function that allows you to grab just those particular bits of data. See how with a few simple examples in this post…

[Head this way for great PostgresSQL blogging >>>]

FIRST_VALUE() Window Function – with example in PostgreSQL.

With Window Functions, there is always something to learn. They have numerous moving parts but allow for powerful queries that return powerful results. I recently learned of (new to me, but not new to the SQL world) another interesting Window Function, FIRST_VALUE(). Read on as I explore more about it…

[Head this way for great PostgresSQL blogging >>>]