Revision 7140
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 228 | 228 |
|
| 229 | 229 |
|
| 230 | 230 |
-- |
| 231 |
-- Name: _merge_prefix(text, text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 232 |
-- |
|
| 233 |
|
|
| 234 |
CREATE FUNCTION _merge_prefix(prefix text DEFAULT NULL::text, value text DEFAULT NULL::text) RETURNS text |
|
| 235 |
LANGUAGE sql IMMUTABLE |
|
| 236 |
AS $_$ |
|
| 237 |
SELECT _join_words((CASE WHEN $2 ~ ('^'||$1||E'\\y') THEN NULL ELSE $1 END), $2)
|
|
| 238 |
$_$; |
|
| 239 |
|
|
| 240 |
|
|
| 241 |
-- |
|
| 231 | 242 |
-- Name: _merge_words(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
| 232 | 243 |
-- |
| 233 | 244 |
|
Also available in: Unified diff
schemas/functions.sql: Added _merge_prefix()