maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_get_location_v2(double precision, double precision)
Parameters
Name
Type
Mode
longitude
double precision
IN
latitude
double precision
IN
Definition
DECLARE var1 text; var2 text; var3 text; BEGIN RETURN hstore('estado','ND') || hstore('ciudad','ND') || hstore('localidad','ND'); EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS var1 = MESSAGE_TEXT, var2 = PG_EXCEPTION_DETAIL, var3 = PG_EXCEPTION_HINT; RAISE WARNING '% % %',var1,var2,var3; RETURN hstore('estado','ND') || hstore('ciudad','ND') || hstore('localidad','ND'); END;