Revision 4760
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 51 | 51 |
|
| 52 | 52 |
|
| 53 | 53 |
-- |
| 54 |
-- Name: _frac_to_pct(double precision); Type: FUNCTION; Schema: functions; Owner: - |
|
| 55 |
-- |
|
| 56 |
|
|
| 57 |
CREATE FUNCTION _frac_to_pct(value double precision) RETURNS double precision |
|
| 58 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 59 |
AS $_$ |
|
| 60 |
SELECT $1*100. |
|
| 61 |
$_$; |
|
| 62 |
|
|
| 63 |
|
|
| 64 |
-- |
|
| 54 | 65 |
-- Name: _if(boolean, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
| 55 | 66 |
-- |
| 56 | 67 |
|
| ... | ... | |
| 172 | 183 |
|
| 173 | 184 |
|
| 174 | 185 |
-- |
| 186 |
-- Name: _pct_to_frac(double precision); Type: FUNCTION; Schema: functions; Owner: - |
|
| 187 |
-- |
|
| 188 |
|
|
| 189 |
CREATE FUNCTION _pct_to_frac(value double precision) RETURNS double precision |
|
| 190 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 191 |
AS $_$ |
|
| 192 |
SELECT $1/100. |
|
| 193 |
$_$; |
|
| 194 |
|
|
| 195 |
|
|
| 196 |
-- |
|
| 175 | 197 |
-- Name: join_strs_transform(text, text, text); Type: FUNCTION; Schema: functions; Owner: - |
| 176 | 198 |
-- |
| 177 | 199 |
|
Also available in: Unified diff
schemas/functions.sql: Added _pct_to_frac()