Skip to content

Instantly share code, notes, and snippets.

@froxxxy
Created January 13, 2016 15:02
Show Gist options
  • Save froxxxy/078ea9038bec2f420927 to your computer and use it in GitHub Desktop.
Save froxxxy/078ea9038bec2f420927 to your computer and use it in GitHub Desktop.
PostgreSQL: The world's most advanced open source database
CREATE SCHEMA world;
CREATE TABLE world.databases (name VARCHAR, advance INTEGER, open_source BOOLEAN);
INSERT INTO world.databases VALUES ('PostgreSQL', 9001, TRUE);
SELECT
name
FROM
world.databases
WHERE
open_source IS TRUE
ORDER BY
advance DESC
LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment