Differences

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

--- podoc:number_of_film_references_sql_function [2007/04/13 07:22] – Luud
+++ podoc:number_of_film_references_sql_function [2007/04/18 14:24] – Luud
@@ Line 6: / Line 6: @@
 === Description ===
+Counts the number of references for a particular film.
+// Tentative (is this correct?): // this represents the number of photos in the database captured on the specified film.
 === Purpose ===
+To retrieve the number of references to a particular film.
 === Schema ===
-  create function number_of_film_references(integer) returns bigint
+<code>
-  as 'select count(photo_tech.identifier)
+create function number_of_film_references(integer) returns bigint
-        from photo_tech, film
+as 'select count(photo_tech.identifier)
-       where photo_tech.film=film.identifier
+      from photo_tech, film
-         and film.identifier = $1' language 'sql';
+     where photo_tech.film=film.identifier
+       and film.identifier = $1' language 'sql';
+</code>
 === Related tables ===
-=== Related indexes ===
+  * [[film sql table|film]]
+  * [[photo_tech sql table|photo_tech]]
-=== Related functions ===
-=== Related views ===
 === History ===
@@ Line 39: / Line 44: @@
 = Version 2.5 =
-  create function number_of_film_references(integer) returns bigint
+<code>
-  as 'select count(photo_tech.identifier)
+create function number_of_film_references(integer) returns bigint
-        from photo_tech, film
+as 'select count(photo_tech.identifier)
-       where photo_tech.film=film.identifier
+      from photo_tech, film
-         and film.identifier = $1' language 'sql';
+     where photo_tech.film=film.identifier
+       and film.identifier = $1' language 'sql';
+</code>