Postgre SQL is admittedly very wrong, however its also perhaps one of the biggest mistakes the project made early on (admitted by various community members).

I'll work to call out the two correct ones, and call out the confusion of the other separately.