User Tools

Site Tools


podoc:number_of_scanner_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
podoc:number_of_scanner_references_sql_function [2007/04/12 12:26]
Luud
podoc:number_of_scanner_references_sql_function [2007/04/23 10:31] (current)
Luud
Line 1: Line 1:
-===== Database ​Sequence ​Description of "​number_of_scanner_references"​ =====+===== Database ​Function ​Description of "​number_of_scanner_references"​ =====
  
 === Name === === Name ===
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Counts the number of references to a particular scanner.
 +
 +Tentative (is this correct?): this represents the number of photos in the database captured using the specified scanner.
  
 === Purpose === === Purpose ===
 +
 +To retrieve the number of references to a particular scanner.
  
 === Schema === === Schema ===
  
-  ​create function number_of_scanner_references(integer) returns bigint +<code sql> 
-  as '​select count(photo_tech.identifier) +create function number_of_scanner_references(integer) returns bigint 
-        from photo_tech, scanner +as '​select count(photo_tech.identifier) 
-       ​where photo_tech.scanner=scanner.identifier +      from photo_tech, scanner 
-         ​and scanner.identifier = $1' language '​sql';​+     ​where photo_tech.scanner=scanner.identifier 
 +       ​and scanner.identifier = $1' language '​sql';​ 
 +</​code>​
  
 === Related tables === === Related tables ===
  
-=== Related indexes === +  * [[photo_tech sql table|photo_tech]] 
- +  * [[scanner sql table|scanner]]
-=== Related functions === +
- +
-=== Related views ===+
  
 === History === === History ===
Line 39: Line 44:
 = Version 2.5 = = Version 2.5 =
  
-  ​create function number_of_scanner_references(integer) returns bigint +<code sql> 
-  as '​select count(photo_tech.identifier) +create function number_of_scanner_references(integer) returns bigint 
-        from photo_tech, scanner +as '​select count(photo_tech.identifier) 
-       ​where photo_tech.scanner=scanner.identifier +      from photo_tech, scanner 
-         ​and scanner.identifier = $1' language '​sql';​+     ​where photo_tech.scanner=scanner.identifier 
 +       ​and scanner.identifier = $1' language '​sql';​ 
 +</​code>​
  
podoc/number_of_scanner_references_sql_function.1176395187.txt.gz · Last modified: 2007/04/12 12:26 by Luud