Revision 14452
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 231 | 231 |
|
| 232 | 232 |
|
| 233 | 233 |
-- |
| 234 |
-- Name: _concat_nullify(text, text); Type: FUNCTION; Schema: util; Owner: - |
|
| 235 |
-- |
|
| 236 |
|
|
| 237 |
CREATE FUNCTION _concat_nullify("0" text DEFAULT NULL::text, "1" text DEFAULT NULL::text) RETURNS text
|
|
| 238 |
LANGUAGE sql IMMUTABLE |
|
| 239 |
AS $_$ |
|
| 240 |
SELECT $1 || $2 |
|
| 241 |
$_$; |
|
| 242 |
|
|
| 243 |
|
|
| 244 |
-- |
|
| 234 | 245 |
-- Name: _dms_to_dd(text); Type: FUNCTION; Schema: util; Owner: - |
| 235 | 246 |
-- |
| 236 | 247 |
|
Also available in: Unified diff
schemas/util.sql: added _concat_nullify(), which uses || instead of concat()