podoc:photo_shop_transaction_references_sql_function
This is an old revision of the document!
Database Function Description of "photo_shop_transaction_references"
Name
photo_shop_transaction_references
Description
Counts the number of shop transactions for a particular photo item.
Tentative (is this correct?): this represents the number of copies of a photo sold.
Purpose
To retrieve the number of shop transactions for a particular photo item.
Schema
create function photo_shop_transaction_references(integer) returns bigint as 'select count(shop_order.transaction) from photo_item, shop_order where photo_item.photo = $1 and photo_item.identifier=shop_order.item' language 'sql';
Related tables
History
Used first
Version 2.29
Used last
Still in use
Change history
= Version 2.29 =
create function photo_shop_transaction_references(integer) returns bigint as 'select count(shop_order.transaction) from photo_item, shop_order where photo_item.photo = $1 and photo_item.identifier=shop_order.item' language 'sql';
podoc/photo_shop_transaction_references_sql_function.1176908303.txt.gz · Last modified: 2007/04/18 14:58 by Luud