Hi Jeremy,
I am bit lost for string_agg in PostgreSQL when converting to Sequel.
How can I write this code with Sequel?
SELECT
"f"."id",
"f"."uid",
string_agg(distinct CAST (dirs.uid AS text), ',' order by CAST
(dirs.uid AS text)) as dirs_uids
FROM "paths" as "f"
JOIN dirs ON "f".id = dirs.folder_id
WHERE (paths.user_idx = 1)
GROUP BY "f".id, "f"."uid"
LIMIT 50
Thanks,
Dennis.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/8c158887-757c-451a-9677-95bcfb269803n%40googlegroups.com.
