Conversation

The fun thing about maintaining something like jOOQ is that I keep running into *every* edge case, and *every* unsupported feature of some RDBMS

Lukas Eder

@lukaseder

Jan 21, 2021

At the same time, so far, PostgreSQL is the only RDBMS I've seen so far that lifts the arbitrary restriction of requiring at least one column in a table.

blog.jooq.org

Creating Tables Dum and Dee in PostgreSQL

I was nerd-sniped: So tables dee and dum are two theoretical tables in SQL, and they can be characterised as such: [Dee] is the relation that has no attributes and a single tuple. It plays the role…

Peter Geoghegan

@petervgeoghegan

Replying to

@lukaseder

Accepting 0 column tables simplifies the implementation of various internal Postgres subsystems, too

1:22 AM · Jan 22, 2021Twitter Web App

Replying to

Oh really? Intriguing! What would be an example of such a simplification?

Replying to

Not supporting zero column tables necessitates weird special cases for ALTER TABLE DROP COLUMN