Revision 13357
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/inputs/CVS/plot_/postprocess.sql | ||
---|---|---|
47 | 47 |
6 Full embargo on data 7 |
48 | 48 |
" (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription) |
49 | 49 |
*/ |
50 |
SELECT public._km_to_m(util._map('0=>NULL, 1=>1, 2=>10, 3=>100, 4=>NULL, 5=>NULL, 6=>NULL', $1::text)::double precision)
|
|
50 |
SELECT util._km_to_m(util._map('0=>NULL, 1=>1, 2=>10, 3=>100, 4=>NULL, 5=>NULL, 6=>NULL', $1::text)::double precision)
|
|
51 | 51 |
$BODY$ |
52 | 52 |
LANGUAGE sql IMMUTABLE |
53 | 53 |
COST 100; |
trunk/inputs/VegBank/plot/postprocess.sql | ||
---|---|---|
52 | 52 |
6 Full embargo on data 7 |
53 | 53 |
" (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription) |
54 | 54 |
*/ |
55 |
SELECT public._km_to_m(util._map('0=>NULL, 1=>1, 2=>10, 3=>100, 4=>NULL, 5=>NULL, 6=>NULL', $1::text)::double precision)
|
|
55 |
SELECT util._km_to_m(util._map('0=>NULL, 1=>1, 2=>10, 3=>100, 4=>NULL, 5=>NULL, 6=>NULL', $1::text)::double precision)
|
|
56 | 56 |
$BODY$ |
57 | 57 |
LANGUAGE sql IMMUTABLE |
58 | 58 |
COST 100; |
Also available in: Unified diff
bugfix: **/postprocess.sql: don't use the public schema, because this creates an unsatisfied dependency while the database is being installed, and breaks `make install`