View source for Gioext

{{#gioext: pg |solab| postgres |  
select p.name,  p.id, p.discriminator ,p.created,  p.products,p.city, string_agg(pr.name, ',') from pvnode p
left outer join pv_pro_nod pp on pp.node_id = p.id
left outer join pvprod  pr on pp.prod_id = pr.id
where p.discriminator = 'company'
group by (p.name, p.id, p.discriminator, p.created)
order by p.created desc 
|GetValue
|
|
|localhost
}}


{{#gioext: pg |solab| postgres |  
select now()

}}

[[Giosparql]]