{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/557","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/557/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/557/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/557/events","html_url":"https://github.com/npgsql/npgsql/issues/557","id":64661957,"number":557,"title":"-infinity no longer supported?","user":{"login":"oldsaltycrab","id":7470552,"avatar_url":"https://avatars.githubusercontent.com/u/7470552?v=3","gravatar_id":"","url":"https://api.github.com/users/oldsaltycrab","html_url":"https://github.com/oldsaltycrab","followers_url":"https://api.github.com/users/oldsaltycrab/followers","following_url":"https://api.github.com/users/oldsaltycrab/following{/other_user}","gists_url":"https://api.github.com/users/oldsaltycrab/gists{/gist_id}","starred_url":"https://api.github.com/users/oldsaltycrab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oldsaltycrab/subscriptions","organizations_url":"https://api.github.com/users/oldsaltycrab/orgs","repos_url":"https://api.github.com/users/oldsaltycrab/repos","events_url":"https://api.github.com/users/oldsaltycrab/events{/privacy}","received_events_url":"https://api.github.com/users/oldsaltycrab/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"milestone":null,"comments":14,"created_at":"2015-03-27T00:11:39Z","updated_at":"2015-03-29T10:37:54Z","closed_at":null,"body":"At a relatively recent revision (4e728f1061e41e25e86089e2499452eac46de465), selecting a ```datetime``` column from a table which has a ```-infinity``` value throws an exception: ```Can't convert infinite timestamp values to DateTime```.\r\n\r\nIt's a very explicit exception, checking that the ```NpgsqlDateTime``` is finite, making me think that the support for ```-infinity``` is gone?  Did the +/- infinity used to return DateTime.Max/Min?\r\n\r\nOur production npgsql (2.2.5) handles these values."},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/87388392","html_url":"https://github.com/npgsql/npgsql/issues/557#issuecomment-87388392","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/557","id":87388392,"user":{"login":"mikkeljohnsen","id":4332970,"avatar_url":"https://avatars.githubusercontent.com/u/4332970?v=3","gravatar_id":"","url":"https://api.github.com/users/mikkeljohnsen","html_url":"https://github.com/mikkeljohnsen","followers_url":"https://api.github.com/users/mikkeljohnsen/followers","following_url":"https://api.github.com/users/mikkeljohnsen/following{/other_user}","gists_url":"https://api.github.com/users/mikkeljohnsen/gists{/gist_id}","starred_url":"https://api.github.com/users/mikkeljohnsen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikkeljohnsen/subscriptions","organizations_url":"https://api.github.com/users/mikkeljohnsen/orgs","repos_url":"https://api.github.com/users/mikkeljohnsen/repos","events_url":"https://api.github.com/users/mikkeljohnsen/events{/privacy}","received_events_url":"https://api.github.com/users/mikkeljohnsen/received_events","type":"User","site_admin":false},"created_at":"2015-03-29T10:37:54Z","updated_at":"2015-03-29T10:37:54Z","body":"@roji Maybe, but then I also have to make queries like \"SELECT * FROM test WHERE date IS NULL OR date < '2015-01-01'\" now I can just do \"SELECT * FROM test WHERE date < '2015-01-01'\" Since date is always a value \"-infinity\"."}}