{"action":"opened","issue":{"url":"https://api.github.com/repos/matthijs/sqlpp11-connector-postgresql/issues/7","labels_url":"https://api.github.com/repos/matthijs/sqlpp11-connector-postgresql/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/matthijs/sqlpp11-connector-postgresql/issues/7/comments","events_url":"https://api.github.com/repos/matthijs/sqlpp11-connector-postgresql/issues/7/events","html_url":"https://github.com/matthijs/sqlpp11-connector-postgresql/issues/7","id":65069684,"number":7,"title":"Use of sqlpp::distaincs flag couses a compiler error","user":{"login":"cszawisza","id":7128531,"avatar_url":"https://avatars.githubusercontent.com/u/7128531?v=3","gravatar_id":"","url":"https://api.github.com/users/cszawisza","html_url":"https://github.com/cszawisza","followers_url":"https://api.github.com/users/cszawisza/followers","following_url":"https://api.github.com/users/cszawisza/following{/other_user}","gists_url":"https://api.github.com/users/cszawisza/gists{/gist_id}","starred_url":"https://api.github.com/users/cszawisza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cszawisza/subscriptions","organizations_url":"https://api.github.com/users/cszawisza/orgs","repos_url":"https://api.github.com/users/cszawisza/repos","events_url":"https://api.github.com/users/cszawisza/events{/privacy}","received_events_url":"https://api.github.com/users/cszawisza/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-29T15:14:14Z","updated_at":"2015-03-29T15:14:14Z","closed_at":null,"body":"Hi\r\nIn my application I need to use distinct keyword in one of my queries, but sadly code below:\r\n```c++\r\n        auto conf = std::shared_ptr<sqlpp::postgresql::connection_config>( new sqlpp::postgresql::connection_config );\r\n        conf->host = \"localhost\";\r\n        conf->dbname = \"postgres\";\r\n        conf->user = \"postgres\";\r\n        conf->password = \"postgres\";\r\n        //    conf->debug = true;\r\n\r\n        sqlpp::postgresql::connection db (conf);\r\n        schema::users u;\r\n        db( select( sqlpp::distinct, u.c_unixperms ).from(u).where(true) );\r\n```\r\ngenerates \r\n```\r\nno member named 'from' in 'sqlpp::bad_statement'\r\n        db( select( sqlpp::distinct, u.c_unixperms ).from(u).where(true) );\r\n            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ^\r\nstatic_assert failed \"at least one argument is not a selectable expression in columns()\"\r\n                                                static_assert(decltype(_check_args(args...))::value, \"at least one argument is not a selectable expression in columns()\");\r\n                                                ^             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n```\r\n\r\nwhere schema::users -> https://github.com/cszawisza/QElectricPartsCatalog/blob/dev/server/sql/users.h\r\n\r\nRegards,\r\ncszawisza"}}