Revision 5728
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 58 | 58 |
|
| 59 | 59 |
|
| 60 | 60 |
-- |
| 61 |
-- Name: _cm_to_m(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 62 |
-- |
|
| 63 |
|
|
| 64 |
CREATE FUNCTION _cm_to_m(value text) RETURNS double precision |
|
| 65 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 66 |
AS $_$ |
|
| 67 |
SELECT functions._cm_to_m($1::double precision) |
|
| 68 |
$_$; |
|
| 69 |
|
|
| 70 |
|
|
| 71 |
-- |
|
| 72 | 61 |
-- Name: _eq(anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
| 73 | 62 |
-- |
| 74 | 63 |
|
| ... | ... | |
| 102 | 91 |
|
| 103 | 92 |
|
| 104 | 93 |
-- |
| 105 |
-- Name: _ft_to_m(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 106 |
-- |
|
| 107 |
|
|
| 108 |
CREATE FUNCTION _ft_to_m(value text) RETURNS double precision |
|
| 109 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 110 |
AS $_$ |
|
| 111 |
SELECT functions._ft_to_m($1::double precision) |
|
| 112 |
$_$; |
|
| 113 |
|
|
| 114 |
|
|
| 115 |
-- |
|
| 116 | 94 |
-- Name: _ha_to_m2(double precision); Type: FUNCTION; Schema: functions; Owner: - |
| 117 | 95 |
-- |
| 118 | 96 |
|
| ... | ... | |
| 124 | 102 |
|
| 125 | 103 |
|
| 126 | 104 |
-- |
| 127 |
-- Name: _ha_to_m2(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 128 |
-- |
|
| 129 |
|
|
| 130 |
CREATE FUNCTION _ha_to_m2(value text) RETURNS double precision |
|
| 131 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 132 |
AS $_$ |
|
| 133 |
SELECT functions._ha_to_m2($1::double precision) |
|
| 134 |
$_$; |
|
| 135 |
|
|
| 136 |
|
|
| 137 |
-- |
|
| 138 | 105 |
-- Name: _if(boolean, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
| 139 | 106 |
-- |
| 140 | 107 |
|
| ... | ... | |
| 168 | 135 |
|
| 169 | 136 |
|
| 170 | 137 |
-- |
| 171 |
-- Name: _in_to_m(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 172 |
-- |
|
| 173 |
|
|
| 174 |
CREATE FUNCTION _in_to_m(value text) RETURNS double precision |
|
| 175 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 176 |
AS $_$ |
|
| 177 |
SELECT functions._in_to_m($1::double precision) |
|
| 178 |
$_$; |
|
| 179 |
|
|
| 180 |
|
|
| 181 |
-- |
|
| 182 | 138 |
-- Name: _join(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
| 183 | 139 |
-- |
| 184 | 140 |
|
| ... | ... | |
| 361 | 317 |
|
| 362 | 318 |
|
| 363 | 319 |
-- |
| 364 |
-- Name: _percent_to_fraction(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 365 |
-- |
|
| 366 |
|
|
| 367 |
CREATE FUNCTION _percent_to_fraction(value text) RETURNS double precision |
|
| 368 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 369 |
AS $_$ |
|
| 370 |
SELECT functions._percent_to_fraction($1::double precision) |
|
| 371 |
$_$; |
|
| 372 |
|
|
| 373 |
|
|
| 374 |
-- |
|
| 375 | 320 |
-- Name: join_strs_transform(text, text, text); Type: FUNCTION; Schema: functions; Owner: - |
| 376 | 321 |
-- |
| 377 | 322 |
|
Also available in: Unified diff
schemas/functions.sql: Removed unit conversion functions that take a text input, since casts to the parameter type (double precision) are now automatically performed by sql_io.put_table(), using sql.parse_exception()'s function MissingCastException parsing