aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_qty
Parameters
Name
Type
Mode
qty
integer
IN
unit
text
IN
unit_plural
text
IN (DEFAULT NULL)
Definition
SELECT CASE WHEN qty > 1 THEN qty||coalesce(' '||unit_plural, ' '||unit||'s') ELSE qty||' '||unit END