Revision 10373
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 1384 | 1384 |
|
| 1385 | 1385 |
|
| 1386 | 1386 |
-- |
| 1387 |
-- Name: nulls_map(text[]); Type: FUNCTION; Schema: util; Owner: - |
|
| 1388 |
-- |
|
| 1389 |
|
|
| 1390 |
CREATE FUNCTION nulls_map(nulls text[]) RETURNS hstore |
|
| 1391 |
LANGUAGE sql IMMUTABLE |
|
| 1392 |
AS $_$ |
|
| 1393 |
SELECT util.hstore($1, NULL) || '*=>*' |
|
| 1394 |
$_$; |
|
| 1395 |
|
|
| 1396 |
|
|
| 1397 |
-- |
|
| 1398 |
-- Name: FUNCTION nulls_map(nulls text[]); Type: COMMENT; Schema: util; Owner: - |
|
| 1399 |
-- |
|
| 1400 |
|
|
| 1401 |
COMMENT ON FUNCTION nulls_map(nulls text[]) IS 'for use with _map()'; |
|
| 1402 |
|
|
| 1403 |
|
|
| 1404 |
-- |
|
| 1387 | 1405 |
-- Name: raise_undefined_column(col_ref); Type: FUNCTION; Schema: util; Owner: - |
| 1388 | 1406 |
-- |
| 1389 | 1407 |
|
Also available in: Unified diff
schemas/util.sql: added nulls_map(), for use with _map()