podoc:count_photo_versions_by_user_sql_function
Database Function Description of "count_photo_versions_by_user"
Name
count_photo_versions_by_user
Description
Count the total number of photo versions of a particular user.
Purpose
To retrieve the total number of photo versions of a particular user.
Schema
CREATE FUNCTION count_photo_versions_by_user(INTEGER) RETURNS BIGINT AS 'select count(photo_version.identifier) from photo_version, photo where photo_version.photo=photo.identifier and photo.users = $1' LANGUAGE 'sql';
Related tables
History
Used first
Version 2.13
Used last
Still in use
Change history
= Version 2.13 =
CREATE FUNCTION count_photo_versions_by_user(INTEGER) RETURNS BIGINT AS 'select count(photo_version.identifier) from photo_version, photo where photo_version.photo=photo.identifier and photo.users = $1' LANGUAGE 'sql';
podoc/count_photo_versions_by_user_sql_function.txt · Last modified: 2007/04/23 14:26 by Luud