{"action":"created","issue":{"url":"https://api.github.com/repos/doctrine/dbal/issues/795","labels_url":"https://api.github.com/repos/doctrine/dbal/issues/795/labels{/name}","comments_url":"https://api.github.com/repos/doctrine/dbal/issues/795/comments","events_url":"https://api.github.com/repos/doctrine/dbal/issues/795/events","html_url":"https://github.com/doctrine/dbal/pull/795","id":56121216,"number":795,"title":"Add tsvector type support in PostgreSQL Platform","user":{"login":"believer-ufa","id":801727,"avatar_url":"https://avatars.githubusercontent.com/u/801727?v=3","gravatar_id":"","url":"https://api.github.com/users/believer-ufa","html_url":"https://github.com/believer-ufa","followers_url":"https://api.github.com/users/believer-ufa/followers","following_url":"https://api.github.com/users/believer-ufa/following{/other_user}","gists_url":"https://api.github.com/users/believer-ufa/gists{/gist_id}","starred_url":"https://api.github.com/users/believer-ufa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/believer-ufa/subscriptions","organizations_url":"https://api.github.com/users/believer-ufa/orgs","repos_url":"https://api.github.com/users/believer-ufa/repos","events_url":"https://api.github.com/users/believer-ufa/events{/privacy}","received_events_url":"https://api.github.com/users/believer-ufa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-01-31T10:51:49Z","updated_at":"2015-01-31T11:23:19Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/doctrine/dbal/pulls/795","html_url":"https://github.com/doctrine/dbal/pull/795","diff_url":"https://github.com/doctrine/dbal/pull/795.diff","patch_url":"https://github.com/doctrine/dbal/pull/795.patch"},"body":"Just one simple string. Maybe add this to code?"},"comment":{"url":"https://api.github.com/repos/doctrine/dbal/issues/comments/72314051","html_url":"https://github.com/doctrine/dbal/pull/795#issuecomment-72314051","issue_url":"https://api.github.com/repos/doctrine/dbal/issues/795","id":72314051,"user":{"login":"believer-ufa","id":801727,"avatar_url":"https://avatars.githubusercontent.com/u/801727?v=3","gravatar_id":"","url":"https://api.github.com/users/believer-ufa","html_url":"https://github.com/believer-ufa","followers_url":"https://api.github.com/users/believer-ufa/followers","following_url":"https://api.github.com/users/believer-ufa/following{/other_user}","gists_url":"https://api.github.com/users/believer-ufa/gists{/gist_id}","starred_url":"https://api.github.com/users/believer-ufa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/believer-ufa/subscriptions","organizations_url":"https://api.github.com/users/believer-ufa/orgs","repos_url":"https://api.github.com/users/believer-ufa/repos","events_url":"https://api.github.com/users/believer-ufa/events{/privacy}","received_events_url":"https://api.github.com/users/believer-ufa/received_events","type":"User","site_admin":false},"created_at":"2015-01-31T11:23:19Z","updated_at":"2015-01-31T11:23:19Z","body":"Hello)\r\n\r\nIts a special type in PgSQL for storing information about some strings for future searching in them through fulltext search technique. Read more about this you can in official docs: http://www.postgresql.org/docs/9.4/static/datatype-textsearch.html\r\n\r\nBut for me and you, simple humans, receiving data from this field uniquely retrieve data from a \"string\" or \"text\" field. Most likely, yes, there is more correct to set the type as \"text\", not \"string\", because data in this field can be long.\r\n\r\nAnd sorry if I suggest that something is not right. I am not a great expert in Doctrine, I just need to specify this type of field in one of their projects for one of the libraries, which receives information from the database through Doctrine."}}