Photo Organizer

number_of_location_references

Counts the number of references to a particular location.

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

To retrieve the number of references to a particular location.

CREATE FUNCTION number_of_location_references(INTEGER) RETURNS BIGINT
AS 'select count(photo.identifier)
      from photo, location
     where photo.location=location.identifier
       and location.identifier = $1' LANGUAGE 'sql';

• location
• photo

Version 2.5

Still in use

= Version 2.5 =

CREATE FUNCTION number_of_location_references(INTEGER) RETURNS BIGINT
AS 'select count(photo.identifier)
      from photo, location
     where photo.location=location.identifier
       and location.identifier = $1' LANGUAGE 'sql';