Photo Organizer

number_of_filter_references

Counts the number of references to a particular filter.

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

To retrieve the number of references to a particular filter.

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

• filter
• photo_tech

Version 2.5

Still in use

= Version 2.5 =

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