Skip to content

Instantly share code, notes, and snippets.

@drbawb

drbawb/gist:2f6a1c8e4e8d7e3e6a3dd2cdeffb41e7

Created June 6, 2019 20:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save drbawb/2f6a1c8e4e8d7e3e6a3dd2cdeffb41e7 to your computer and use it in GitHub Desktop.
Save drbawb/2f6a1c8e4e8d7e3e6a3dd2cdeffb41e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
alleluia=# select * from tags; │···
id | name | description | created_at | updated_at │···
----+-------------------+-------------+----------------------------+---------------------------- │···
1 | trailers | | 2015-03-21 00:50:51.892679 | 2015-03-21 00:50:51.892679 │···
2 | birds | | 2015-03-21 00:51:39.282225 | 2015-03-21 00:51:39.282225 │···
3 | mostly just birds | | 2015-03-21 00:51:39.289174 | 2015-03-21 00:51:39.289174 │···
4 | raptors | | 2015-03-21 00:51:39.293133 | 2015-03-21 00:51:39.293133 │···
5 | owls | | 2015-03-21 00:51:39.298342 | 2015-03-21 00:51:39.298342 │···
6 | flamingos | | 2015-03-21 01:10:18.523834 | 2015-03-21 01:10:18.523834 │···
7 | ??? | | 2015-03-21 01:11:22.709125 | 2015-03-21 01:11:22.709125 │···
14 | Frogs | | 2015-03-23 02:22:50.2744 | 2015-03-23 02:22:50.2744 │···
16 | Show me the Green | | 2015-03-23 02:23:07.326554 | 2015-03-23 02:23:07.326554 │···
15 | Kermick | | 2015-03-23 02:22:56.508412 | 2015-03-23 02:58:06.119662 │···
17 | Kermick Clones | | 2015-03-23 02:34:53.054728 | 2015-03-23 02:58:48.806057 │···
8 | mystery | | 2015-03-22 20:27:50.575166 | 2015-03-24 17:22:26.447021 │···
9 | spooky times | | 2015-03-22 20:29:00.45132 | 2015-03-24 17:22:26.453734 │···
10 | fish tanks | | 2015-03-22 20:29:23.586761 | 2015-03-24 17:22:26.4627 │···
11 | lemons | | 2015-03-22 20:29:30.545615 | 2015-03-24 17:22:26.469831 │···
12 | seashells | | 2015-03-22 20:29:46.796151 | 2015-03-24 17:22:26.473706 │···
13 | too many tags | | 2015-03-22 20:30:22.352345 | 2015-03-24 17:22:26.478194 │···
(17 rows) │···
│···
alleluia=# select ROW(id, name) FROM tags; │···
row │···
-------------------------- │···
(1,trailers) │···
(2,birds) │···
(3,"mostly just birds") │···
(4,raptors) │···
(5,owls) │···
(6,flamingos) │···
(7,???) │···
(14,Frogs) │···
(16,"Show me the Green") │···
(15,Kermick) │···
(17,"Kermick Clones") │···
(8,mystery) │···
(9,"spooky times") │···
(10,"fish tanks") │···
(11,lemons) │···
(12,seashells) │···
(13,"too many tags") │···
(17 rows) │···
│···
alleluia=# select * from tags │···
alleluia-# WHERE ROW(id, name) IN (ROW(1, 'trailers'), ROW(2, 'birds')) │···
alleluia-# ; │···
id | name | description | created_at | updated_at │···
----+----------+-------------+----------------------------+---------------------------- │···
1 | trailers | | 2015-03-21 00:50:51.892679 | 2015-03-21 00:50:51.892679 │···
2 | birds | | 2015-03-21 00:51:39.282225 | 2015-03-21 00:51:39.282225 │···
(2 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment