maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_get_device_conf(character varying)
Parameters
Name
Type
Mode
serialnumber
character varying
IN
Definition
WITH q as (select dc.iddeviceconf,dc.configname,dc.defaultval,ddc.configval dev_configval FROM deviceconf dc LEFT JOIN device d ON d.idmodeldevice = dc.idmodeldevice JOIN device_deviceconf ddc ON ddc.iddevice = d.iddevice and ddc.iddeviceconf = dc.iddeviceconf WHERE d.serialnumber = $1 and length(trim(ddc.configval)) > 0), q1 as (SELECT iddeviceconf,configname,defaultval,dev_configval FROM q) ,q2 as (SELECT string_agg(iddeviceconf||'=>'||coalesce(quote_ident(dev_configval),'null'),',') res FROM q1) SELECT hstore(res) from q2