User Tools

Site Tools


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';

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 11:59 by Luud