Skip to content

Instantly share code, notes, and snippets.

@rgarner

rgarner/thing.md

Last active August 29, 2015 14:03
Show Gist options
  • Save rgarner/7cccbc504de7c8d56702 to your computer and use it in GitHub Desktop.
Save rgarner/7cccbc504de7c8d56702 to your computer and use it in GitHub Desktop.
Download ZIP
Silly Postgres truth
Raw
thing.md

SELECT L <> R FROM table;

L R L <> R L IS DISTINCT FROM R
NULL NULL NULL f
1 NULL NULL t
NULL 1 NULL t
1 1 f f
1 2 t t
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment