tag:blogger.com,1999:blog-8333362953216176367.post5817826992629942482..comments2022-07-24T21:57:29.200+02:00Comments on The plate is bad: Hexastores are easyergohttp://www.blogger.com/profile/06303496169445217331noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8333362953216176367.post-4138798850396045592016-08-19T14:58:08.850+02:002016-08-19T14:58:08.850+02:00You could use some SQL beautifier, it's hard t...You could use some SQL beautifier, it's hard to read. <br /><br />SELECT A.t || B.t || C.t AS ord,<br /> A.v,<br /> B.v,<br /> C.v<br />FROM<br /> (SELECT *<br /> FROM unnest(ARRAY[sub, pred, obj],ARRAY['s', 'p', 'o'])) AS A(v, t)<br />CROSS JOIN<br /> (SELECT *<br /> FROM unnest(ARRAY[sub, pred, obj],ARRAY['s', 'p', 'o'])) AS B(v, t)<br />CROSS JOIN<br /> (SELECT *<br /> FROM unnest(ARRAY[sub, pred, obj],ARRAY['s', 'p', 'o'])) AS C(v, t)<br />WHERE a.v != b.v<br /> AND a.v != c.v<br /> AND b.v != c.v<br />ORDER BY ord DESCmocne haslohttps://bezpiecznehaslo.pl/noreply@blogger.com