aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_user_attribute
Parameters
Name
Type
Mode
column_name
text
IN
user_name
text
IN (DEFAULT NULL)
Definition
SELECT user_value FROM dblink( fn_conn_authen(), format($$SELECT u.%I FROM user_property p INNER JOIN users u ON u.id = p.user_id WHERE p.prop_id = %L AND upper(u.user_name) = upper(%L)$$, column_name, fn_prop_id(), COALESCE(user_name, fn_current_user()) ) ) AS (user_value TEXT)