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 >>>]

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 >>>]

Searched CASE expression in PostgreSQL – with examples.

In this blog post, we will look at one type of ‘conditional formatting’ that enables you to perform complex calculations. PostgreSQL (and SQL in general) provides us with a couple of variants of the CASE statement which could be used for this very thing, among many many others. Learn with me as I make my way through writing this post…

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

Handy string functions: right() and left() with examples in PostgreSQL

In this blog post, I will visit a couple of handy string functions for extracting a specified number of characters from a string of text. Yet, with both functions, you can start from a certain position. Either left (beginning) or right (the end). Let’s see them in action with some examples…

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