User Tools

Site Tools


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';

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