Project

General

Profile

« Previous | Next » 

Revision 7140

schemas/functions.sql: Added _merge_prefix()

View differences:

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