User Tools

Site Tools


podoc:number_of_scanner_references_sql_function

Database Function Description of "number_of_scanner_references"

Name

number_of_scanner_references

Description

Counts the number of references to a particular scanner.

Tentative (is this correct?): this represents the number of photos in the database captured using the specified scanner.

Purpose

To retrieve the number of references to a particular scanner.

Schema

CREATE FUNCTION number_of_scanner_references(INTEGER) RETURNS BIGINT
AS 'select count(photo_tech.identifier)
      from photo_tech, scanner
     where photo_tech.scanner=scanner.identifier
       and scanner.identifier = $1' LANGUAGE 'sql';

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

CREATE FUNCTION number_of_scanner_references(INTEGER) RETURNS BIGINT
AS 'select count(photo_tech.identifier)
      from photo_tech, scanner
     where photo_tech.scanner=scanner.identifier
       and scanner.identifier = $1' LANGUAGE 'sql';
podoc/number_of_scanner_references_sql_function.txt · Last modified: 2007/04/23 10:31 by Luud