Differences

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

--- podoc:number_of_scanner_references_sql_function [2007/04/12 12:26] – Luud
+++ podoc:number_of_scanner_references_sql_function [2007/04/18 14:52] – Luud
@@ Line 1: / Line 1: @@
-===== Database Function Description =====
+===== Database Function Description of "number_of_scanner_references" =====
 === Name ===
+number_of_scanner_references
 === 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 ===
+To retrieve the number of references to a particular scanner.
 === Schema ===
+<code>
+create function number_of_scanner_references(integer) returns bigint
+as 'select count(photo_tech.identifier)
+      from photo_tech, scanner
+     where photo_tech.scanner=scanner.identifier
+       and scanner.identifier = $1' language 'sql';
+</code>
 === Related tables ===
-=== Related views ===
+  * [[photo_tech sql table|photo_tech]]
+  * [[scanner sql table|scanner]]
-=== Related sequences ===
-=== Related indexes ===
 === History ===
@@ Line 31: / Line 44: @@
 = Version 2.5 =
-  create function ... (
+<code>
-    ...
+create function number_of_scanner_references(integer) returns bigint
-  );
+as 'select count(photo_tech.identifier)
+      from photo_tech, scanner
+     where photo_tech.scanner=scanner.identifier
+       and scanner.identifier = $1' language 'sql';
+</code>