aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_prop_query
Parameters
Name
Type
Mode
prop_code
text
IN
sql_text
text
IN
Definition
DECLARE prop_conn TEXT; BEGIN prop_conn = (SELECT conn FROM dblink(fn_conn_authen(), format('Select fn_prop_connection(%L)', coalesce(prop_code, fn_current_propcode()))) AS res(conn text)); RETURN QUERY SELECT * FROM dblink(prop_conn, sql_text); END;