[Firebug-cvs] fireboard/beta/bin sirf_functions.pgsql,NONE,1.1 firebug-db-setup.sh,1.3,1.4 sirf_id2_
Brought to you by:
doolin
From: David M. D. <do...@us...> - 2005-07-29 23:26:43
|
Update of /cvsroot/firebug/fireboard/beta/bin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24367 Modified Files: firebug-db-setup.sh sirf_id2_1.pgsql Added Files: sirf_functions.pgsql Log Message: Added functions for converting sirf data on queries. --- NEW FILE: sirf_functions.pgsql --- create or replace function velocity(int /* raw position */) returns real as 'select ( $1 / 8.0 )::real as result;' language sql; create or replace function dop(int /* raw dop */) returns real as 'select ($1/2.0)::real as result;' language sql; create or replace function get_gps_tow(int) returns real as 'select ($1/100.0)::real as result;' language sql; Index: sirf_id2_1.pgsql =================================================================== RCS file: /cvsroot/firebug/fireboard/beta/bin/sirf_id2_1.pgsql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** sirf_id2_1.pgsql 15 Jul 2005 16:37:01 -0000 1.1 --- sirf_id2_1.pgsql 29 Jul 2005 23:26:31 -0000 1.2 *************** *** 17,20 **** --- 17,22 ---- zvel smallint, mode1 smallint, + dop smallint, + mode2 smallint, gps_week smallint); Index: firebug-db-setup.sh =================================================================== RCS file: /cvsroot/firebug/fireboard/beta/bin/firebug-db-setup.sh,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** firebug-db-setup.sh 15 Jul 2005 16:37:01 -0000 1.3 --- firebug-db-setup.sh 29 Jul 2005 23:26:31 -0000 1.4 *************** *** 54,58 **** psql --echo-queries --dbname firebug firebug < sirf_id28_3.pgsql ! #### The following are just examples of how to set up --- 54,58 ---- psql --echo-queries --dbname firebug firebug < sirf_id28_3.pgsql ! psql --echo-queries --dbname firebug firebug < sirf_functions.pgsql; #### The following are just examples of how to set up |