{"action":"closed","issue":{"url":"https://api.github.com/repos/HazyResearch/ddlog/issues/25","labels_url":"https://api.github.com/repos/HazyResearch/ddlog/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/HazyResearch/ddlog/issues/25/comments","events_url":"https://api.github.com/repos/HazyResearch/ddlog/issues/25/events","html_url":"https://github.com/HazyResearch/ddlog/issues/25","id":93576431,"number":25,"title":"PG built-in Function with Constant Arg","user":{"login":"zhangce","id":1608867,"avatar_url":"https://avatars.githubusercontent.com/u/1608867?v=3","gravatar_id":"","url":"https://api.github.com/users/zhangce","html_url":"https://github.com/zhangce","followers_url":"https://api.github.com/users/zhangce/followers","following_url":"https://api.github.com/users/zhangce/following{/other_user}","gists_url":"https://api.github.com/users/zhangce/gists{/gist_id}","starred_url":"https://api.github.com/users/zhangce/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhangce/subscriptions","organizations_url":"https://api.github.com/users/zhangce/orgs","repos_url":"https://api.github.com/users/zhangce/repos","events_url":"https://api.github.com/users/zhangce/events{/privacy}","received_events_url":"https://api.github.com/users/zhangce/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/HazyResearch/ddlog/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"feiranwang","id":5935656,"avatar_url":"https://avatars.githubusercontent.com/u/5935656?v=3","gravatar_id":"","url":"https://api.github.com/users/feiranwang","html_url":"https://github.com/feiranwang","followers_url":"https://api.github.com/users/feiranwang/followers","following_url":"https://api.github.com/users/feiranwang/following{/other_user}","gists_url":"https://api.github.com/users/feiranwang/gists{/gist_id}","starred_url":"https://api.github.com/users/feiranwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/feiranwang/subscriptions","organizations_url":"https://api.github.com/users/feiranwang/orgs","repos_url":"https://api.github.com/users/feiranwang/repos","events_url":"https://api.github.com/users/feiranwang/events{/privacy}","received_events_url":"https://api.github.com/users/feiranwang/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-07-07T16:46:39Z","updated_at":"2015-07-07T19:03:43Z","closed_at":"2015-07-07T19:03:43Z","body":"Consider the following query:\r\n\r\n        sentences_serialized(\r\n\t        docid, \r\n        \tsentid, \r\n\t        !array_to_string(wordidxs, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(words, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(poses, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(ners, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(lemmas, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(dep_paths, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(dep_parents, \"@@@@@\", \"*\"), \r\n\t        !array_to_string(bounding_boxes, \"@@@@@\", \"*\")) *\r\n\t        :- sentences(docid, sentid, wordidxs, words, poses, ners, lemmas, dep_paths, dep_parents, bounding_boxes).\r\n\r\nWhen I use \" in array_to_string (which is WRONG in PG because \" is column name, ' is string). I got in DD:\r\n\r\n        function array_to_string(integer[], unknown, unknown) does not exist\r\n\r\nWhen I do \"@@@@@\"::text, I got in ddlib\r\n\r\n        [error] paleo.ddl[54.36] failure: `)' expected but `:' found\r\n        !array_to_string(wordidxs, \"@@@@@\"::text, \"*\"::text), \r\n\r\nWhen I use `'` instead, I got in ddlib, \r\n\r\n        [error] paleo.ddl[54.29] failure: string matching regex \\p{javaJavaIdentifierStart}\\p{javaJavaIdentifierPart}*' expected but '' found\r\n        !array_to_string(wordidxs, '@@@@@', '*'), \r\n\r\n@netj @feiranwang Can you guys help me with this? I want to serialize a text array to strings with separater \"@@@@@\"... \r\n\r\nAlso, I think we have TODO that support better array as primitive type, but the above way is the one I think is right to do right now before that TODO is finished...\r\n\r\n\r\n\r\n\r\n\r\n"}}