Revision 5839
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 124 | 124 |
|
| 125 | 125 |
|
| 126 | 126 |
-- |
| 127 |
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: - |
|
| 128 |
-- |
|
| 129 |
|
|
| 130 |
|
|
| 131 |
|
|
| 132 |
|
|
| 133 |
-- |
|
| 127 | 134 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 128 | 135 |
-- |
| 129 | 136 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 290 | 290 |
|
| 291 | 291 |
|
| 292 | 292 |
-- |
| 293 |
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: - |
|
| 294 |
-- |
|
| 295 |
|
|
| 296 |
CREATE FUNCTION _cm_to_m(value double precision) RETURNS double precision |
|
| 297 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 298 |
AS $_$ |
|
| 299 |
SELECT $1/100. |
|
| 300 |
$_$; |
|
| 301 |
|
|
| 302 |
|
|
| 303 |
-- |
|
| 293 | 304 |
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 294 | 305 |
-- |
| 295 | 306 |
|
Also available in: Unified diff
schemas/vegbien.sql: Copied _cm_to_m() to public schema for use by new aggregated_analytical_db_view