number_of_lens_references
Counts the number of references to a particular lens.
Tentative (is this correct?): this represents the number of photos in the database captured using the specified lens.
To retrieve the number of references to a particular lens.
CREATE FUNCTION number_of_lens_references(INTEGER) RETURNS BIGINT AS 'select count(photo_tech.identifier) from photo_tech, lens where photo_tech.lens=lens.identifier and lens.identifier = $1' LANGUAGE 'sql';
Version 2.5
Still in use
= Version 2.5 =
CREATE FUNCTION number_of_lens_references(INTEGER) RETURNS BIGINT AS 'select count(photo_tech.identifier) from photo_tech, lens where photo_tech.lens=lens.identifier and lens.identifier = $1' LANGUAGE 'sql';