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/13 07:20] – Luud
@@ Line 1: / Line 1: @@
-===== Database Function Description =====
+===== Database Function Description of "number_of_scanner_references" =====
 === Name ===
+number_of_scanner_references
 === Description ===
@@ Line 8: / Line 10: @@
 === Schema ===
+  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';
 === Related tables ===
-=== Related views ===
+=== Related indexes ===
-=== Related sequences ===
+=== Related functions ===
-=== Related indexes ===
+=== Related views ===
 === History ===
@@ Line 31: / Line 39: @@
 = Version 2.5 =
-  create function ... (
+  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';