Revision 10699
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 221 | 221 |
|
| 222 | 222 |
|
| 223 | 223 |
-- |
| 224 |
-- Name: _join(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: util; Owner: -
|
|
| 224 |
-- Name: _join(text, text, text, text, text, text, text, text, text, text); Type: FUNCTION; Schema: util; Owner: -
|
|
| 225 | 225 |
-- |
| 226 | 226 |
|
| 227 |
CREATE FUNCTION _join("0" anyelement DEFAULT NULL::unknown, "1" anyelement DEFAULT NULL::unknown, "2" anyelement DEFAULT NULL::unknown, "3" anyelement DEFAULT NULL::unknown, "4" anyelement DEFAULT NULL::unknown, "5" anyelement DEFAULT NULL::unknown, "6" anyelement DEFAULT NULL::unknown, "7" anyelement DEFAULT NULL::unknown, "8" anyelement DEFAULT NULL::unknown, "9" anyelement DEFAULT NULL::unknown) RETURNS anyelement
|
|
| 227 |
CREATE FUNCTION _join("0" text DEFAULT NULL::text, "1" text DEFAULT NULL::text, "2" text DEFAULT NULL::text, "3" text DEFAULT NULL::text, "4" text DEFAULT NULL::text, "5" text DEFAULT NULL::text, "6" text DEFAULT NULL::text, "7" text DEFAULT NULL::text, "8" text DEFAULT NULL::text, "9" text DEFAULT NULL::text) RETURNS text
|
|
| 228 | 228 |
LANGUAGE sql IMMUTABLE |
| 229 | 229 |
AS $_$ |
| 230 | 230 |
SELECT NULLIF(concat_ws('; ', $1, $2, $3, $4, $5, $6, $7, $8, $9, $10), '')
|
| ... | ... | |
| 232 | 232 |
|
| 233 | 233 |
|
| 234 | 234 |
-- |
| 235 |
-- Name: _join_words(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: util; Owner: -
|
|
| 235 |
-- Name: _join_words(text, text, text, text, text, text, text, text, text, text); Type: FUNCTION; Schema: util; Owner: -
|
|
| 236 | 236 |
-- |
| 237 | 237 |
|
| 238 |
CREATE FUNCTION _join_words("0" anyelement DEFAULT NULL::unknown, "1" anyelement DEFAULT NULL::unknown, "2" anyelement DEFAULT NULL::unknown, "3" anyelement DEFAULT NULL::unknown, "4" anyelement DEFAULT NULL::unknown, "5" anyelement DEFAULT NULL::unknown, "6" anyelement DEFAULT NULL::unknown, "7" anyelement DEFAULT NULL::unknown, "8" anyelement DEFAULT NULL::unknown, "9" anyelement DEFAULT NULL::unknown) RETURNS anyelement
|
|
| 238 |
CREATE FUNCTION _join_words("0" text DEFAULT NULL::text, "1" text DEFAULT NULL::text, "2" text DEFAULT NULL::text, "3" text DEFAULT NULL::text, "4" text DEFAULT NULL::text, "5" text DEFAULT NULL::text, "6" text DEFAULT NULL::text, "7" text DEFAULT NULL::text, "8" text DEFAULT NULL::text, "9" text DEFAULT NULL::text) RETURNS text
|
|
| 239 | 239 |
LANGUAGE sql IMMUTABLE |
| 240 | 240 |
AS $_$ |
| 241 | 241 |
SELECT NULLIF(concat_ws(' ', $1, $2, $3, $4, $5, $6, $7, $8, $9, $10), '')
|
| ... | ... | |
| 243 | 243 |
|
| 244 | 244 |
|
| 245 | 245 |
-- |
| 246 |
-- Name: _label(anyelement, anyelement); Type: FUNCTION; Schema: util; Owner: -
|
|
| 246 |
-- Name: _label(text, text); Type: FUNCTION; Schema: util; Owner: -
|
|
| 247 | 247 |
-- |
| 248 | 248 |
|
| 249 |
CREATE FUNCTION _label(label anyelement, value anyelement) RETURNS anyelement
|
|
| 249 |
CREATE FUNCTION _label(label text, value text) RETURNS text
|
|
| 250 | 250 |
LANGUAGE sql IMMUTABLE |
| 251 | 251 |
AS $_$ |
| 252 | 252 |
SELECT coalesce($1 || ': ', '') || $2 |
Also available in: Unified diff
schemas/util.sql: combining functions taking anyelement params which could be text: take text param instead, so that other argument types (e.g. integer) will first be implicitly cast to text instead of trying to concatenate integers directly. this fixes a bug in the VegBank.stemcount_,stemlocation_ _join() of two integer pkeys, which first needed to be cast to text. anyelement was previously used so that other text-like types such as varchar could also be used, but varchar is implicitly castable to text so keeping anyelement should not be necessary.