Photo Organizer

User Tools

Site Tools

Trace:
podoc:count_photos_by_user_sql_function

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
podoc:count_photos_by_user_sql_function [2007/04/18 13:37] – Luudpodoc:count_photos_by_user_sql_function [2007/04/23 14:27] (current) – Luud
Line 17: Line 17:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create function count_photos_by_user(integer) returns bigint create function count_photos_by_user(integer) returns bigint
 as 'select count(identifier) from photo where users = $1' language 'sql'; as 'select count(identifier) from photo where users = $1' language 'sql';
 </code> </code>
  
-<code>+<code sql>
 create function count_photos_by_user(integer, integer) returns bigint create function count_photos_by_user(integer, integer) returns bigint
 as 'select count(photo.identifier) as 'select count(photo.identifier)
Line 59: Line 59:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create function count_photos_by_user(integer) returns bigint create function count_photos_by_user(integer) returns bigint
 as 'select count(identifier) from photo where users = $1' language 'sql'; as 'select count(identifier) from photo where users = $1' language 'sql';
 </code> </code>
  
-<code>+<code sql>
 create function count_photos_by_user(integer, integer) returns bigint create function count_photos_by_user(integer, integer) returns bigint
 as 'select count(photo.identifier) as 'select count(photo.identifier)
Line 76: Line 76:
 = Version 2.8 = = Version 2.8 =
  
-<code>+<code sql>
 -- Count photos per user for a specified access level. -- Count photos per user for a specified access level.
 -- A photo is accessible (visible), if its parent folder and the -- A photo is accessible (visible), if its parent folder and the
podoc/count_photos_by_user_sql_function.txt · Last modified: 2007/04/23 14:27 by Luud