podoc:is_photo_for_sale_sql_function
Database Function Description of "is_photo_for_sale"
Name
is_photo_for_sale
Description
Checks if a photo is for sale or not.
Purpose
To retrieve the ability/permission of a photo to be sold.
Schema
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';
Related tables
History
Used first
Version 2.8
Used last
Version 2.34
Change history
= 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);
podoc/is_photo_for_sale_sql_function.txt · Last modified: 2007/10/19 15:59 by Luud