podoc:number_of_camera_references_sql_function
Database Function Description of "number_of_camera_references"
Name
number_of_camera_references
Description
Counts the number of references for a specific camera.
Tentative (is this correct?): this represents the number of photos in the database generated by the specified camera.
Purpose
To retrieve the number of references to a particular camera.
Schema
CREATE FUNCTION number_of_camera_references(INTEGER) RETURNS BIGINT AS 'select count(photo_tech.identifier) from photo_tech, camera where photo_tech.camera=camera.identifier and camera.identifier = $1' LANGUAGE 'sql';
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
CREATE FUNCTION number_of_camera_references(INTEGER) RETURNS BIGINT AS 'select count(photo_tech.identifier) from photo_tech, camera where photo_tech.camera=camera.identifier and camera.identifier = $1' LANGUAGE 'sql';
podoc/number_of_camera_references_sql_function.txt · Last modified: 2007/04/23 14:30 by Luud