Photo Organizer

User Tools

Site Tools

Trace:
podoc:count_photos_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_sql_function [2007/04/18 13:05] – Luudpodoc:count_photos_sql_function [2007/04/23 14:26] (current) – Luud
Line 17: Line 17:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create function count_photos() returns bigint create function count_photos() returns bigint
 as 'select count(identifier) from photo' language 'sql'; as 'select count(identifier) from photo' language 'sql';
 </code> </code>
  
-<code>+<code sql>
 create function count_photos(integer) returns bigint create function count_photos(integer) returns bigint
 as 'select count(identifier) from photo where access_rights <= $1' language 'sql'; as 'select count(identifier) from photo where access_rights <= $1' language 'sql';
Line 45: Line 45:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create function count_photos() returns bigint create function count_photos() returns bigint
 as 'select count(identifier) from photo' language 'sql'; as 'select count(identifier) from photo' language 'sql';
 </code> </code>
  
-<code>+<code sql>
 create function count_photos(integer) returns bigint create function count_photos(integer) returns bigint
 as 'select count(identifier) from photo where access_rights <= $1' language 'sql'; as 'select count(identifier) from photo where access_rights <= $1' language 'sql';
 </code> </code>
  
podoc/count_photos_sql_function.txt · Last modified: 2007/04/23 14:26 by Luud