aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_propertyinfo_json
Parameters
Name
Type
Mode
Definition
declare result json; BEGIN with props as ( select json_build_object( 'prop_id', p.prop_id, 'prop_code', p.prop_code, 'prop_name', p.name, 'company', p.company, 'address1', p.address1, 'address2', p.address2, 'address3', p.address3, 'address4', p.address4, 'email', p.email, 'telephone', p.telephone, 'fax', p.fax, 'website', p.website, 'logo_type', p.logo_type, 'logo', p.logo_url ) as json_data from property_info p limit 1 ) select s.json_data into result from props s; return result; END;