podoc:number_of_scanner_references_sql_function
This is an old revision of the document!
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';
Related tables
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.1176907976.txt.gz · Last modified: 2007/04/18 14:52 by Luud