User Tools

Site Tools


podoc:count_users_sql_function

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:count_users_sql_function [2007/04/12 16:19] Luudpodoc:count_users_sql_function [2007/04/23 14:29] (current) Luud
Line 1: Line 1:
-===== Database Sequence Description of "count_users" =====+===== Database Function Description of "count_users" =====
  
 === Name === === Name ===
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Count the total number of users.
  
 === Purpose === === Purpose ===
 +
 +To retrieve the total number of users.
  
 === Schema === === Schema ===
  
-  create function count_users() returns bigint +<code sql> 
-  as 'select count(identifier) from users' language 'sql';+create function count_users() returns bigint 
 +as 'select count(identifier) from users' language 'sql'; 
 +</code>
  
 === Related tables === === Related tables ===
  
-=== Related indexes === +  * [[users sql table|users]]
- +
-=== Related functions === +
- +
-=== Related views ===+
  
 === History === === History ===
Line 36: Line 38:
 = Version 2.5 = = Version 2.5 =
  
-  create function count_users() returns bigint +<code sql> 
-  as 'select count(identifier) from users' language 'sql';+create function count_users() returns bigint 
 +as 'select count(identifier) from users' language 'sql'; 
 +</code>
  
podoc/count_users_sql_function.1176394790.txt.gz · Last modified: 2007/04/12 16:19 by Luud