count_photo_versions_by_user

Count the total number of photo versions of a particular user.

To retrieve the total number of photo versions of a particular user.

CREATE FUNCTION count_photo_versions_by_user(integer) returns bigint
AS 'select count(photo_version.identifier) from photo_version, photo
where photo_version.photo=photo.identifier and photo.users = $1' LANGUAGE 'sql';

• photo
• photo_version

Version 2.13

Still in use

= Version 2.13 =

CREATE FUNCTION count_photo_versions_by_user(integer) returns bigint
AS 'select count(photo_version.identifier) from photo_version, photo
where photo_version.photo=photo.identifier and photo.users = $1' LANGUAGE 'sql';