Differences

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

--- podoc:number_of_dupes_sql_function [2007/04/13 07:22] – Luud
+++ podoc:number_of_dupes_sql_function [2007/04/23 14:30] (current) – Luud
@@ Line 6: / Line 6: @@
 === Description ===
+Count the number of photo duplicates.
 === Purpose ===
+To return the number of photo duplicates.
 === Schema ===
-  create function number_of_dupes(integer) returns bigint
+<code sql>
-  as 'select count(identifier) from photo_dupe where photo = $1' language 'sql';
+create function number_of_dupes(integer) returns bigint
+as 'select count(identifier) from photo_dupe where photo = $1' language 'sql';
+</code>
 === Related tables ===
-=== Related indexes ===
+  * [[photo_dupe sql table|photo_dupe]]
-=== Related functions ===
-=== Related views ===
 === History ===
@@ Line 36: / Line 38: @@
 = Version 2.5 =
-  create function number_of_dupes(integer) returns bigint
+<code sql>
-  as 'select count(identifier) from photo_dupe where photo = $1' language 'sql';
+create function number_of_dupes(integer) returns bigint
+as 'select count(identifier) from photo_dupe where photo = $1' language 'sql';
+</code>