User Tools

Site Tools


podoc:number_of_camera_references_sql_function

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
podoc:number_of_camera_references_sql_function [2007/04/13 07:22] Luudpodoc:number_of_camera_references_sql_function [2007/04/18 14:15] Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Counts the number of references for a specific camera.
 +
 +//Tentative (is this correct?):// this represents the number of photos in the database generated by the specified camera.
  
 === Purpose === === Purpose ===
 +
 +To retrieve the number of references to a particular camera.
  
 === Schema === === Schema ===
  
-  create function number_of_camera_references(integer) returns bigint +<code> 
-  as 'select count(photo_tech.identifier) +create function number_of_camera_references(integer) returns bigint 
-        from photo_tech, camera +as 'select count(photo_tech.identifier) 
-       where photo_tech.camera=camera.identifier +      from photo_tech, camera 
-         and camera.identifier = $1' language 'sql';+     where photo_tech.camera=camera.identifier 
 +       and camera.identifier = $1' language 'sql'; 
 +</code>
  
 === Related tables === === Related tables ===
  
-=== Related indexes === +  * [[camera sql table|camera]] 
- +  * [[photo_tech sql table|photo_tech]]
-=== Related functions === +
- +
-=== Related views ===+
  
 === History === === History ===
Line 39: Line 44:
 = Version 2.5 = = Version 2.5 =
  
-  create function number_of_camera_references(integer) returns bigint +<code> 
-  as 'select count(photo_tech.identifier) +create function number_of_camera_references(integer) returns bigint 
-        from photo_tech, camera +as 'select count(photo_tech.identifier) 
-       where photo_tech.camera=camera.identifier +      from photo_tech, camera 
-         and camera.identifier = $1' language 'sql';+     where photo_tech.camera=camera.identifier 
 +       and camera.identifier = $1' language 'sql'; 
 +</code>
  
podoc/number_of_camera_references_sql_function.txt · Last modified: 2007/04/23 14:30 by Luud