User Tools

Site Tools


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 revision Previous revision
podoc:count_photos_by_user_sql_function [2007/04/18 09:37]
Luud
podoc:count_photos_by_user_sql_function [2007/04/23 10: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 10:27 by Luud