On Mon, Nov 13, 2017 at 2:41 AM, Andreas Karlsson <andr...@proxel.se> wrote:
> I think the code would look cleaner if you generate the following query: > > SELECT fk.x, fk.ys FROM ONLY t2 fk CROSS JOIN LATERAL > pg_catalog.unnest(ys) a2 (v) LEFT OUTER JOIN ONLY t1 pk ON pk.x = fk.x AND > pk.y = a2.v WHERE [...] > > rather than: > > SELECT fk.k1, fk.ak2 FROM (SELECT x k1, pg_catalog.unnest(ys) k2, ys ak2 > FROM ONLY t2) fk LEFT OUTER JOIN ONLY t1 pk ON pk.x = fk.k1 AND pk.y = > fk.k2 WHERE [...] > Andreas has kindly written the SQL query for us. My problem is generating it with C code Best Regards, Mark Rofail