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 Both sides next revision
podoc:number_of_scanner_references_sql_function [2007/04/13 03:20]
Luud
podoc:number_of_scanner_references_sql_function [2007/04/18 10:52]
Luud
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>​ 
-  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>​ 
-  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.txt · Last modified: 2007/04/23 10:31 by Luud