is_photo_for_sale

Checks if a photo is for sale or not.

To retrieve the ability/permission of a photo to be sold.

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

• photo
• photo_item

Version 2.8

Version 2.34

= Version 2.8 =

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

= Version 2.34 =

DROP FUNCTION is_photo_for_sale(integer);