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 revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
podoc:number_of_camera_references_sql_function [2007/04/12 08:26]
Luud
podoc:number_of_camera_references_sql_function [2007/04/18 10:22]
Luud
Line 1: Line 1:
-===== Database Function Description =====+===== Database Function Description ​of "​number_of_camera_references" ​=====
  
 === Name === === Name ===
 +
 +number_of_camera_references
  
 === 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 ===
 +
 +<​code>​
 +create function number_of_camera_references(integer) returns bigint
 +as '​select count(photo_tech.identifier)
 +      from photo_tech, camera
 +     where photo_tech.camera=camera.identifier
 +       and camera.identifier = $1' language '​sql';​
 +</​code>​
  
 === Related tables === === Related tables ===
  
-=== Related views === +  * [[camera sql table|camera]] 
- +  * [[photo_tech sql table|photo_tech]]
-=== Related sequences === +
- +
-=== Related indexes ===+
  
 === History === === History ===
Line 31: Line 44:
 = Version 2.5 = = Version 2.5 =
  
-  ​create function ​... +<​code>​ 
-    ...   +create function ​number_of_camera_references(integer) returns bigint 
-  );+as '​select count(photo_tech.identifier) 
 +      from photo_tech, camera 
 +     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 10:30 by Luud