Elein’s PlanetPostgreSQL Archives - 2ndQuadrant

WITH a little help from my friends

March 19, 2020/0 Comments/in Elein’s PlanetPostgreSQL /by Elein

* and if you don’t like the weather, go out and make some of your own! (apologies to Scoop Nisker) Get a little help for your queries WITH data sources that can be predefined and precalculated as well as clarify where your data is coming from and how. PostgreSQL 12 has added a feature […]

Postgresql Interval, Date, Timestamp and Time Data Types

July 9, 2019/0 Comments/in Elein’s PlanetPostgreSQL /by Elein

Beautiful things, strings.

May 31, 2019/0 Comments/in Elein’s PlanetPostgreSQL /by Elein

Postgresql String Functions and Operators. This blog today is going to talk about strings: how they are stored, how they are input, and lots of examples of how to use string operators and functions in order to manipulate them. Strings, strings, strings. What we are not going to cover is regular expressions, although we […]

Swoop de Dupe

May 29, 2019/11 Comments/in Elein’s PlanetPostgreSQL /by Elein

The problem: duplicate rows Once upon a time, there was a database person who knows about referential integrity and its importance for creating database tables. The interesting part is that referential integrity, including primary keys, enable keeping with the standard of not having duplicate rows. However, they just wanted a private little table on their […]

Having Group By Clauses — elein’s GeneralBits

March 18, 2019/0 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by Elein

Some people go to great lengths to avoid GROUP BY and HAVING clauses in their queries. The error messages are fussy but they are usually right. GROUP BY and HAVING key words are essential for good SQL reporting. The primary reason for GROUP BY is to reduce the number of rows, usually by aggregation. It […]

JOIN LATERAL

March 1, 2019/2 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by Elein

2ndQuadrant is now part of EDB

WITH a little help from my friends

Postgresql Interval, Date, Timestamp and Time Data Types

Beautiful things, strings.

Swoop de Dupe

Having Group By Clauses — elein’s GeneralBits

JOIN LATERAL

Support & Services

Products

Postgres Learning Center

About Us