aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_path
Parameters
Name
Type
Mode
path1
text
IN
path2
text
IN
Definition
SELECT CASE WHEN (path1 LIKE '%/') THEN path1||COALESCE(path2,'') ELSE path1||'/'||COALESCE(path2,'') END