User Tools

Site Tools


podoc:number_of_camera_references_sql_function

This is an old revision of the document!


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

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.1176905710.txt.gz · Last modified: 2007/04/18 10:15 by Luud