Differences

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

--- podoc:number_of_camera_references_sql_function [2007/04/12 12:20] – created Luud
+++ podoc:number_of_camera_references_sql_function [2007/04/13 07:22] – Luud
@@ Line 1: / Line 1: @@
-===== Database Function Description =====
+===== Database Function Description of "number_of_camera_references" =====
 === Name ===
+number_of_camera_references
 === Description ===
@@ Line 9: / Line 11: @@
 === Schema ===
-=== Related tables===
+  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';
-=== Related sequences ===
+=== Related tables ===
 === Related indexes ===
+=== Related functions ===
+=== Related views ===
 === History ===
@@ Line 29: / Line 39: @@
 = Version 2.5 =
-  create function ... (
+  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';