Revision 12444
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1753 | 1753 |
-- |
| 1754 | 1754 |
|
| 1755 | 1755 |
CREATE FUNCTION join_strs_transform(state text, value text, delim text) RETURNS text |
| 1756 |
LANGUAGE sql IMMUTABLE |
|
| 1756 |
LANGUAGE sql IMMUTABLE STRICT
|
|
| 1757 | 1757 |
AS $_$ |
| 1758 | 1758 |
SELECT $1 || $3 || $2 |
| 1759 | 1759 |
$_$; |
| 1760 | 1760 |
|
| 1761 | 1761 |
|
| 1762 | 1762 |
-- |
| 1763 |
-- Name: FUNCTION join_strs_transform(state text, value text, delim text); Type: COMMENT; Schema: util; Owner: - |
|
| 1764 |
-- |
|
| 1765 |
|
|
| 1766 |
COMMENT ON FUNCTION join_strs_transform(state text, value text, delim text) IS ' |
|
| 1767 |
must be declared STRICT to use the special handling of STRICT aggregating functions |
|
| 1768 |
'; |
|
| 1769 |
|
|
| 1770 |
|
|
| 1771 |
-- |
|
| 1763 | 1772 |
-- Name: keys(anyelement); Type: FUNCTION; Schema: util; Owner: - |
| 1764 | 1773 |
-- |
| 1765 | 1774 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: join_strs_transform(): added back STRICT qualifier because it must be declared STRICT to use the special handling of STRICT aggregating functions