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
|
