[Firebug-cvs] fireboard/beta/bin sirf_functions.pgsql,NONE,1.1 firebug-db-setup.sh,1.3,1.4 sirf_id2_1.pgsql,1.1,1.2

[David M. D. <do...@us...>]

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