http://solab.eu/solab/index.php?action=history&feed=atom&title=Gioext 2026-04-21T19:43:24Z Revision history for this page on the wiki MediaWiki 1.44.2 http://solab.eu/solab/index.php?title=Gioext&diff=68491&oldid=prev 2022-09-20T20:39:30Z

<p></p> <p><b>New page</b></p><div>{{#gioext: pg |solab| postgres | <br /> select p.name, p.id, p.discriminator ,p.created, p.products,p.city, string_agg(pr.name, &#039;,&#039;) from pvnode p<br /> left outer join pv_pro_nod pp on pp.node_id = p.id<br /> left outer join pvprod pr on pp.prod_id = pr.id<br /> where p.discriminator = &#039;company&#039;<br /> group by (p.name, p.id, p.discriminator, p.created)<br /> order by p.created desc <br /> |GetValue<br /> |<br /> |<br /> |localhost<br /> }}<br /> <br /> <br /> {{#gioext: pg |solab| postgres | <br /> select now()<br /> <br /> }}<br /> <br /> [[Giosparql]]</div>

Gio