User Tools

Site Tools


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 revision Previous revision
podoc:count_photos_sql_function [2007/04/18 09:05]
Luud
podoc:count_photos_sql_function [2007/04/23 10: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 10:26 by Luud