{"action":"created","issue":{"url":"https://api.github.com/repos/pgRouting/pgrouting/issues/493","repository_url":"https://api.github.com/repos/pgRouting/pgrouting","labels_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/493/labels{/name}","comments_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/493/comments","events_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/493/events","html_url":"https://github.com/pgRouting/pgrouting/issues/493","id":134922382,"number":493,"title":"pgr_pointsaspolygon first argument select with text","user":{"login":"opessoa","id":4539871,"avatar_url":"https://avatars.githubusercontent.com/u/4539871?v=3","gravatar_id":"","url":"https://api.github.com/users/opessoa","html_url":"https://github.com/opessoa","followers_url":"https://api.github.com/users/opessoa/followers","following_url":"https://api.github.com/users/opessoa/following{/other_user}","gists_url":"https://api.github.com/users/opessoa/gists{/gist_id}","starred_url":"https://api.github.com/users/opessoa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/opessoa/subscriptions","organizations_url":"https://api.github.com/users/opessoa/orgs","repos_url":"https://api.github.com/users/opessoa/repos","events_url":"https://api.github.com/users/opessoa/events{/privacy}","received_events_url":"https://api.github.com/users/opessoa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-02-19T17:23:16Z","updated_at":"2016-02-22T13:32:52Z","closed_at":null,"body":"Hi guys, I'm using pgr_pointsaspolygon to generate a polygon from my points, but, I have a select with date comparison, something like this:\r\n\r\n`select st_astext(pgr_pointsaspolygon('select id, st_x(the_geom) as x,st_y(the_geom) as y from rota_destino where date(dt_hr) = ''17/02/2016'' and id_rota = 0 order by ordem'));`\r\n\r\nThis results in:\r\n\r\n`ERROR:  syntax error at or near \"17\"\r\nLINE 1: ...geom) as y from rota_destino where date(dt_hr) = '17/02/2016...\r\n                                                             ^\r\nQUERY:  SELECT x, y FROM pgr_alphashape('select id, st_x(the_geom) as x,st_y(the_geom) as y from rota_destino where date(dt_hr) = '17/02/2016' and id_rota = 0 order by ordem', 0)\r\nCONTEXT:  PL/pgSQL function pgr_pointsaspolygon(character varying,double precision) line 17 at FOR over EXECUTE statement ... `\r\n\r\nHow can I solve it?"},"comment":{"url":"https://api.github.com/repos/pgRouting/pgrouting/issues/comments/187174562","html_url":"https://github.com/pgRouting/pgrouting/issues/493#issuecomment-187174562","issue_url":"https://api.github.com/repos/pgRouting/pgrouting/issues/493","id":187174562,"user":{"login":"dkastl","id":227762,"avatar_url":"https://avatars.githubusercontent.com/u/227762?v=3","gravatar_id":"","url":"https://api.github.com/users/dkastl","html_url":"https://github.com/dkastl","followers_url":"https://api.github.com/users/dkastl/followers","following_url":"https://api.github.com/users/dkastl/following{/other_user}","gists_url":"https://api.github.com/users/dkastl/gists{/gist_id}","starred_url":"https://api.github.com/users/dkastl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dkastl/subscriptions","organizations_url":"https://api.github.com/users/dkastl/orgs","repos_url":"https://api.github.com/users/dkastl/repos","events_url":"https://api.github.com/users/dkastl/events{/privacy}","received_events_url":"https://api.github.com/users/dkastl/received_events","type":"User","site_admin":false},"created_at":"2016-02-22T13:32:52Z","updated_at":"2016-02-22T13:32:52Z","body":"As far as I know you need to fork the repository, make the changes (you can probably do this also in the browser), then initiate a pull request: https://help.github.com/articles/using-pull-requests/\r\n\r\nPlease use the `develop` branch as a base for changes. The `develop` branch should be also the branch to reference as target for the pull request."}}