{"action":"created","comment":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/comments/43331846","id":43331846,"diff_hunk":"@@ -0,0 +1,158 @@\n+SELECT keyed_min(x, -x) FROM generate_series(1, 1000) AS x;\n+ keyed_min \n+-----------\n+        -1\n+(1 row)\n+\n+SELECT keyed_min(-x::float, x::int8) FROM generate_series(1, 1000) AS x;\n+ keyed_min \n+-----------\n+         1","path":"src/test/regress/expected/keyed_min_max.out","position":10,"original_position":10,"commit_id":"10b54f29494651946990ebbee6f5620b8930ceae","original_commit_id":"10b54f29494651946990ebbee6f5620b8930ceae","user":{"login":"derekjn","id":384666,"avatar_url":"https://avatars.githubusercontent.com/u/384666?v=3","gravatar_id":"","url":"https://api.github.com/users/derekjn","html_url":"https://github.com/derekjn","followers_url":"https://api.github.com/users/derekjn/followers","following_url":"https://api.github.com/users/derekjn/following{/other_user}","gists_url":"https://api.github.com/users/derekjn/gists{/gist_id}","starred_url":"https://api.github.com/users/derekjn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/derekjn/subscriptions","organizations_url":"https://api.github.com/users/derekjn/orgs","repos_url":"https://api.github.com/users/derekjn/repos","events_url":"https://api.github.com/users/derekjn/events{/privacy}","received_events_url":"https://api.github.com/users/derekjn/received_events","type":"User","site_admin":false},"body":"Yea, I'm making a couple more changes, I'll reopen in a sec.","created_at":"2015-10-28T23:21:04Z","updated_at":"2015-10-28T23:21:04Z","html_url":"https://github.com/pipelinedb/pipelinedb/pull/1243#discussion_r43331846","pull_request_url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243","_links":{"self":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/comments/43331846"},"html":{"href":"https://github.com/pipelinedb/pipelinedb/pull/1243#discussion_r43331846"},"pull_request":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243"}}},"pull_request":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243","id":49079438,"html_url":"https://github.com/pipelinedb/pipelinedb/pull/1243","diff_url":"https://github.com/pipelinedb/pipelinedb/pull/1243.diff","patch_url":"https://github.com/pipelinedb/pipelinedb/pull/1243.patch","issue_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1243","number":1243,"state":"open","locked":false,"title":"#1210 Add keyed min/max aggregate","user":{"login":"derekjn","id":384666,"avatar_url":"https://avatars.githubusercontent.com/u/384666?v=3","gravatar_id":"","url":"https://api.github.com/users/derekjn","html_url":"https://github.com/derekjn","followers_url":"https://api.github.com/users/derekjn/followers","following_url":"https://api.github.com/users/derekjn/following{/other_user}","gists_url":"https://api.github.com/users/derekjn/gists{/gist_id}","starred_url":"https://api.github.com/users/derekjn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/derekjn/subscriptions","organizations_url":"https://api.github.com/users/derekjn/orgs","repos_url":"https://api.github.com/users/derekjn/repos","events_url":"https://api.github.com/users/derekjn/events{/privacy}","received_events_url":"https://api.github.com/users/derekjn/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-10-28T23:05:15Z","updated_at":"2015-10-28T23:21:05Z","closed_at":null,"merged_at":null,"merge_commit_sha":"c4541d35a688d277afc41c42d5d78fb3168ba87f","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243/commits","review_comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243/comments","review_comment_url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1243/comments","statuses_url":"https://api.github.com/repos/pipelinedb/pipelinedb/statuses/10b54f29494651946990ebbee6f5620b8930ceae","head":{"label":"pipelinedb:1210-first-last","ref":"1210-first-last","sha":"10b54f29494651946990ebbee6f5620b8930ceae","user":{"login":"pipelinedb","id":5367380,"avatar_url":"https://avatars.githubusercontent.com/u/5367380?v=3","gravatar_id":"","url":"https://api.github.com/users/pipelinedb","html_url":"https://github.com/pipelinedb","followers_url":"https://api.github.com/users/pipelinedb/followers","following_url":"https://api.github.com/users/pipelinedb/following{/other_user}","gists_url":"https://api.github.com/users/pipelinedb/gists{/gist_id}","starred_url":"https://api.github.com/users/pipelinedb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pipelinedb/subscriptions","organizations_url":"https://api.github.com/users/pipelinedb/orgs","repos_url":"https://api.github.com/users/pipelinedb/repos","events_url":"https://api.github.com/users/pipelinedb/events{/privacy}","received_events_url":"https://api.github.com/users/pipelinedb/received_events","type":"Organization","site_admin":false},"repo":{"id":14702444,"name":"pipelinedb","full_name":"pipelinedb/pipelinedb","owner":{"login":"pipelinedb","id":5367380,"avatar_url":"https://avatars.githubusercontent.com/u/5367380?v=3","gravatar_id":"","url":"https://api.github.com/users/pipelinedb","html_url":"https://github.com/pipelinedb","followers_url":"https://api.github.com/users/pipelinedb/followers","following_url":"https://api.github.com/users/pipelinedb/following{/other_user}","gists_url":"https://api.github.com/users/pipelinedb/gists{/gist_id}","starred_url":"https://api.github.com/users/pipelinedb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pipelinedb/subscriptions","organizations_url":"https://api.github.com/users/pipelinedb/orgs","repos_url":"https://api.github.com/users/pipelinedb/repos","events_url":"https://api.github.com/users/pipelinedb/events{/privacy}","received_events_url":"https://api.github.com/users/pipelinedb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pipelinedb/pipelinedb","description":"The Streaming SQL Database","fork":false,"url":"https://api.github.com/repos/pipelinedb/pipelinedb","forks_url":"https://api.github.com/repos/pipelinedb/pipelinedb/forks","keys_url":"https://api.github.com/repos/pipelinedb/pipelinedb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pipelinedb/pipelinedb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pipelinedb/pipelinedb/teams","hooks_url":"https://api.github.com/repos/pipelinedb/pipelinedb/hooks","issue_events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/events{/number}","events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/events","assignees_url":"https://api.github.com/repos/pipelinedb/pipelinedb/assignees{/user}","branches_url":"https://api.github.com/repos/pipelinedb/pipelinedb/branches{/branch}","tags_url":"https://api.github.com/repos/pipelinedb/pipelinedb/tags","blobs_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/refs{/sha}","trees_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pipelinedb/pipelinedb/statuses/{sha}","languages_url":"https://api.github.com/repos/pipelinedb/pipelinedb/languages","stargazers_url":"https://api.github.com/repos/pipelinedb/pipelinedb/stargazers","contributors_url":"https://api.github.com/repos/pipelinedb/pipelinedb/contributors","subscribers_url":"https://api.github.com/repos/pipelinedb/pipelinedb/subscribers","subscription_url":"https://api.github.com/repos/pipelinedb/pipelinedb/subscription","commits_url":"https://api.github.com/repos/pipelinedb/pipelinedb/commits{/sha}","git_commits_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/commits{/sha}","comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/comments{/number}","issue_comment_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/comments{/number}","contents_url":"https://api.github.com/repos/pipelinedb/pipelinedb/contents/{+path}","compare_url":"https://api.github.com/repos/pipelinedb/pipelinedb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pipelinedb/pipelinedb/merges","archive_url":"https://api.github.com/repos/pipelinedb/pipelinedb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pipelinedb/pipelinedb/downloads","issues_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues{/number}","pulls_url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls{/number}","milestones_url":"https://api.github.com/repos/pipelinedb/pipelinedb/milestones{/number}","notifications_url":"https://api.github.com/repos/pipelinedb/pipelinedb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pipelinedb/pipelinedb/labels{/name}","releases_url":"https://api.github.com/repos/pipelinedb/pipelinedb/releases{/id}","created_at":"2013-11-26T00:11:48Z","updated_at":"2015-10-27T09:00:41Z","pushed_at":"2015-10-28T23:05:15Z","git_url":"git://github.com/pipelinedb/pipelinedb.git","ssh_url":"git@github.com:pipelinedb/pipelinedb.git","clone_url":"https://github.com/pipelinedb/pipelinedb.git","svn_url":"https://github.com/pipelinedb/pipelinedb","homepage":"https://www.pipelinedb.com","size":60518,"stargazers_count":676,"watchers_count":676,"language":"C","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":29,"mirror_url":null,"open_issues_count":57,"forks":29,"open_issues":57,"watchers":676,"default_branch":"master"}},"base":{"label":"pipelinedb:master","ref":"master","sha":"29ea9f2fe611304fe192e5ab1a2c5e8afd1ca53e","user":{"login":"pipelinedb","id":5367380,"avatar_url":"https://avatars.githubusercontent.com/u/5367380?v=3","gravatar_id":"","url":"https://api.github.com/users/pipelinedb","html_url":"https://github.com/pipelinedb","followers_url":"https://api.github.com/users/pipelinedb/followers","following_url":"https://api.github.com/users/pipelinedb/following{/other_user}","gists_url":"https://api.github.com/users/pipelinedb/gists{/gist_id}","starred_url":"https://api.github.com/users/pipelinedb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pipelinedb/subscriptions","organizations_url":"https://api.github.com/users/pipelinedb/orgs","repos_url":"https://api.github.com/users/pipelinedb/repos","events_url":"https://api.github.com/users/pipelinedb/events{/privacy}","received_events_url":"https://api.github.com/users/pipelinedb/received_events","type":"Organization","site_admin":false},"repo":{"id":14702444,"name":"pipelinedb","full_name":"pipelinedb/pipelinedb","owner":{"login":"pipelinedb","id":5367380,"avatar_url":"https://avatars.githubusercontent.com/u/5367380?v=3","gravatar_id":"","url":"https://api.github.com/users/pipelinedb","html_url":"https://github.com/pipelinedb","followers_url":"https://api.github.com/users/pipelinedb/followers","following_url":"https://api.github.com/users/pipelinedb/following{/other_user}","gists_url":"https://api.github.com/users/pipelinedb/gists{/gist_id}","starred_url":"https://api.github.com/users/pipelinedb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pipelinedb/subscriptions","organizations_url":"https://api.github.com/users/pipelinedb/orgs","repos_url":"https://api.github.com/users/pipelinedb/repos","events_url":"https://api.github.com/users/pipelinedb/events{/privacy}","received_events_url":"https://api.github.com/users/pipelinedb/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pipelinedb/pipelinedb","description":"The Streaming SQL Database","fork":false,"url":"https://api.github.com/repos/pipelinedb/pipelinedb","forks_url":"https://api.github.com/repos/pipelinedb/pipelinedb/forks","keys_url":"https://api.github.com/repos/pipelinedb/pipelinedb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pipelinedb/pipelinedb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pipelinedb/pipelinedb/teams","hooks_url":"https://api.github.com/repos/pipelinedb/pipelinedb/hooks","issue_events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/events{/number}","events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/events","assignees_url":"https://api.github.com/repos/pipelinedb/pipelinedb/assignees{/user}","branches_url":"https://api.github.com/repos/pipelinedb/pipelinedb/branches{/branch}","tags_url":"https://api.github.com/repos/pipelinedb/pipelinedb/tags","blobs_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/refs{/sha}","trees_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pipelinedb/pipelinedb/statuses/{sha}","languages_url":"https://api.github.com/repos/pipelinedb/pipelinedb/languages","stargazers_url":"https://api.github.com/repos/pipelinedb/pipelinedb/stargazers","contributors_url":"https://api.github.com/repos/pipelinedb/pipelinedb/contributors","subscribers_url":"https://api.github.com/repos/pipelinedb/pipelinedb/subscribers","subscription_url":"https://api.github.com/repos/pipelinedb/pipelinedb/subscription","commits_url":"https://api.github.com/repos/pipelinedb/pipelinedb/commits{/sha}","git_commits_url":"https://api.github.com/repos/pipelinedb/pipelinedb/git/commits{/sha}","comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/comments{/number}","issue_comment_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/comments{/number}","contents_url":"https://api.github.com/repos/pipelinedb/pipelinedb/contents/{+path}","compare_url":"https://api.github.com/repos/pipelinedb/pipelinedb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pipelinedb/pipelinedb/merges","archive_url":"https://api.github.com/repos/pipelinedb/pipelinedb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pipelinedb/pipelinedb/downloads","issues_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues{/number}","pulls_url":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls{/number}","milestones_url":"https://api.github.com/repos/pipelinedb/pipelinedb/milestones{/number}","notifications_url":"https://api.github.com/repos/pipelinedb/pipelinedb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pipelinedb/pipelinedb/labels{/name}","releases_url":"https://api.github.com/repos/pipelinedb/pipelinedb/releases{/id}","created_at":"2013-11-26T00:11:48Z","updated_at":"2015-10-27T09:00:41Z","pushed_at":"2015-10-28T23:05:15Z","git_url":"git://github.com/pipelinedb/pipelinedb.git","ssh_url":"git@github.com:pipelinedb/pipelinedb.git","clone_url":"https://github.com/pipelinedb/pipelinedb.git","svn_url":"https://github.com/pipelinedb/pipelinedb","homepage":"https://www.pipelinedb.com","size":60518,"stargazers_count":676,"watchers_count":676,"language":"C","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":29,"mirror_url":null,"open_issues_count":57,"forks":29,"open_issues":57,"watchers":676,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243"},"html":{"href":"https://github.com/pipelinedb/pipelinedb/pull/1243"},"issue":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1243"},"comments":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1243/comments"},"review_comments":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243/comments"},"review_comment":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/pulls/1243/commits"},"statuses":{"href":"https://api.github.com/repos/pipelinedb/pipelinedb/statuses/10b54f29494651946990ebbee6f5620b8930ceae"}}}}