number_of_camera_references

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.

To retrieve the number of references to a particular camera.

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

• camera
• photo_tech

Version 2.5

Still in use

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