User Tools

Site Tools


podoc:count_photos_by_folder_sql_function

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
podoc:count_photos_by_folder_sql_function [2007/04/18 13:25] Luudpodoc:count_photos_by_folder_sql_function [2007/04/23 14:27] Luud
Line 17: Line 17:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create function count_photos_by_folder(integer) returns bigint create function count_photos_by_folder(integer) returns bigint
 as 'select count(identifier) from photo where folder = $1' language 'sql'; as 'select count(identifier) from photo where folder = $1' language 'sql';
 </code> </code>
  
-<code>+<code sql>
 create function count_photos_by_folder(integer, integer) returns bigint create function count_photos_by_folder(integer, integer) returns bigint
 as 'select count(identifier) from photo where folder = $1 and access_rights <= $2' language 'sql'; as 'select count(identifier) from photo where folder = $1 and access_rights <= $2' language 'sql';
Line 45: Line 45:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create function count_photos_by_folder(integer) returns bigint create function count_photos_by_folder(integer) returns bigint
 as 'select count(identifier) from photo where folder = $1' language 'sql'; as 'select count(identifier) from photo where folder = $1' language 'sql';
 </code> </code>
  
-<code>+<code sql>
 create function count_photos_by_folder(integer, integer) returns bigint create function count_photos_by_folder(integer, integer) returns bigint
 as 'select count(identifier) from photo where folder = $1 and access_rights <= $2' language 'sql'; as 'select count(identifier) from photo where folder = $1 and access_rights <= $2' language 'sql';
 </code> </code>
  
podoc/count_photos_by_folder_sql_function.txt · Last modified: 2007/10/19 20:27 by Luud