{"action":"created","issue":{"url":"https://api.github.com/repos/petere/pgemailaddr/issues/1","repository_url":"https://api.github.com/repos/petere/pgemailaddr","labels_url":"https://api.github.com/repos/petere/pgemailaddr/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/petere/pgemailaddr/issues/1/comments","events_url":"https://api.github.com/repos/petere/pgemailaddr/issues/1/events","html_url":"https://github.com/petere/pgemailaddr/issues/1","id":118666609,"number":1,"title":"Custom type that expects valid TLD","user":{"login":"fnando","id":3009,"avatar_url":"https://avatars.githubusercontent.com/u/3009?v=3","gravatar_id":"","url":"https://api.github.com/users/fnando","html_url":"https://github.com/fnando","followers_url":"https://api.github.com/users/fnando/followers","following_url":"https://api.github.com/users/fnando/following{/other_user}","gists_url":"https://api.github.com/users/fnando/gists{/gist_id}","starred_url":"https://api.github.com/users/fnando/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fnando/subscriptions","organizations_url":"https://api.github.com/users/fnando/orgs","repos_url":"https://api.github.com/users/fnando/repos","events_url":"https://api.github.com/users/fnando/events{/privacy}","received_events_url":"https://api.github.com/users/fnando/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-11-24T17:46:22Z","updated_at":"2016-04-30T23:55:43Z","closed_at":null,"body":"Right now this column type isn't that useful, because it accepts `a@a` as a valid e-mail address, which it is according to the spec, but is not really valid on the real world.\r\n\r\nWould be nice to have another data type that validates the hostname as a valid TLD."},"comment":{"url":"https://api.github.com/repos/petere/pgemailaddr/issues/comments/216003611","html_url":"https://github.com/petere/pgemailaddr/issues/1#issuecomment-216003611","issue_url":"https://api.github.com/repos/petere/pgemailaddr/issues/1","id":216003611,"user":{"login":"pvh","id":2880,"avatar_url":"https://avatars.githubusercontent.com/u/2880?v=3","gravatar_id":"","url":"https://api.github.com/users/pvh","html_url":"https://github.com/pvh","followers_url":"https://api.github.com/users/pvh/followers","following_url":"https://api.github.com/users/pvh/following{/other_user}","gists_url":"https://api.github.com/users/pvh/gists{/gist_id}","starred_url":"https://api.github.com/users/pvh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pvh/subscriptions","organizations_url":"https://api.github.com/users/pvh/orgs","repos_url":"https://api.github.com/users/pvh/repos","events_url":"https://api.github.com/users/pvh/events{/privacy}","received_events_url":"https://api.github.com/users/pvh/received_events","type":"User","site_admin":false},"created_at":"2016-04-30T23:55:43Z","updated_at":"2016-04-30T23:55:43Z","body":"@petere What if the TLDs were listed as a table within the extension's namespace and were enforced via an optional domain constraint?"}}